Restoring SQL Server2K backup onto SQL Server Express 2005

Is there any way to restore a full database backup made on sql server 2000
to SQL Server Express 2005? When I tried, I received an error message saying
the *.sho file could not be found.
Thanks,
Keith
hi Keith,
keithb wrote:
> Is there any way to restore a full database backup made on sql server
> 2000 to SQL Server Express 2005? When I tried, I received an error
> message saying the *.sho file could not be found.
actually it is... when a SQL Server 2000 database is restored onto a SQL
Server 2005 instance, it's database compatibility setting will not be ported
to 90, and you have some issues to fix (if you want to), like modifying the
compatibility level if you want the new SQL Server 2005 features to be
available for that database, update all statistics with FULL SCAN as they
get invalidated and set the database ownership to a valid login if you need
to access database diagrams..
and usually restoring a SQL Server 2000 database backup is a painless task..
I can only think of a SQL Server 2000 database exceeding the SQLExpress
limit of 4gb.. just that.. but I do not reaaly know what a "*.sho" file is..
how did you tried that?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply