Restore help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restore help

Author

Topic

bogey
Posting Yak Master

166 Posts

Posted - 2005-02-09 : 16:07:13

I have a user that needs to restore a backup onto a new machine with a new database name. I've got the backup but how do I do the restore. I've got only one file and thats backup from last week.

thanks.

nr
SQLTeam MVY

12543 Posts

Posted - 2005-02-09 : 16:45:56

in enterprise manager right click on databases
all tasks, restore
restore as database - type in database name
from device, select devices - select the backup file
options - overtype the path names with an existing path on the server
ok

And it should restore the backup

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

bogey
Posting Yak Master

166 Posts

Posted - 2005-02-09 : 21:45:06

I tried that but I was gettin some wierd errors messages. I'm at home right now but I'll try again tomorrow

bogey
Posting Yak Master

166 Posts

Posted - 2005-02-10 : 09:34:48

I tried this again. I had to user the restore filelistonly to get the logical names of the mdf and ldf files. So I tried this:
restore database TESTER2
from disk = 'd:\Gsobackups'
with move 'UOP_GSO' to 'd:\tester2.mdf',
move 'UOP_GSO_log' to 'd:\tester2_log.ldf',norecovery

I'm now getting the error:
Server: Msg 3241, Level 16, State 41, Line 1
The media family on device 'd:\Gsobackups' is incorrectly formed. SQL Server cannot process this media family.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources