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

Restoring from unknown .mdf file

My company received a drive with SQL 2000? .mdf and .ldf files. I don't know if they were detached or just copied. I've been unable to reattach the files and get the error bellow when I try sp_attach_db.

Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\ocwp.mdf' may be incorrect.

Is there anyway to get this data back short of asking for a new backup?

Thanks,

Tim

The restore is attemping to put the files back in the same location they were located on the original server.

Use the [ WITH MOVE ] option for RESTORE. (From Books Online.)

RESTORE DATABASE { database_name }

FROM <backup_device>

WITH MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name' ]

|||

I was able to get this working by creating a new database with the same name, stopping the SQL instance, replacing the newly created .mdf and .ldf files with the ones with data and restarting the instance. Then I found out they were for 2005 and had to redue to process.

Thanks though.

Tim

Restoring from Backup without logs

We have received a backup file that is 6G in size. The log file is
about 74G while the MDF is about 5 G when we restored. Is there a way
to run a SQL script to restore the .BAK file without restoring the log
file as we do not have enough space on the server.

PS. We are running Sql2K5.

Thanks!GM,

See my recent entry under "Restore database with no log". From what I
just went through, I think that your first and best option is to
tell the database owner/administrator to do a backup of the
transaction log, shrink the file and then send you
another backup. If you can't do that, you'll have to find a server
with enough disk space (NTFS, not FAT) to
on which to restore your backup so that you can shrink the logs
yourself. See Erland's advice to me on this matter.

http://groups.google.com/group/comp...0626d528f12287c
Bill E.

GM wrote:

Quote:

Originally Posted by

We have received a backup file that is 6G in size. The log file is
about 74G while the MDF is about 5 G when we restored. Is there a way
to run a SQL script to restore the .BAK file without restoring the log
file as we do not have enough space on the server.
>
PS. We are running Sql2K5.
>
Thanks!