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.
| Author |
Topic |
|
suniel074
Starting Member
1 Post |
 Posted - 2005-11-23 : 23:13:06
|
| Hello all,I have a database backup in .BAK format and i need to restore it to server.I tried RESTORE DATABASE sglue_mdFROM DISK = 'C:\sglue_md_20050804b.bak'WITH REPLACE, MOVE 'DBName_Data' TO 'C:\MSSQL\DATA\sglue_md_Data.MDF',MOVE 'sglue_md_Log' TO 'C:\MSSQL\DATA\sglue_md_Log.LDF'But i got the following errorServer: Msg 3234, Level 16, State 2, Line 1Logical file 'sglue_md' is not part of database 'sglue_md'. UseRESTORE FILELISTONLY to list the logical file names.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.Can someone tell me how I can use the .bak file to copy the database to the server?Thanks in advance,Sunil |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-24 : 03:38:00
|
| do a restore filelistonly to check the logical names and update the move statements accordingly.==========================================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. |
 |
|
|
|
|
|
restoring database