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 |
|
JohnBGood
Starting Member
48 Posts |
 Posted - 2009-12-22 : 14:55:53
|
| When restoring a database from server A to server B, do i need to have the same SQL instance name on both machines?? I've been trying to restore a db on machines that have disimilar names and it is failing - dont know why. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-12-22 : 15:40:33
|
| Also add the SQL statement you are using for the restore. IF using SSMS or EM, maybe the screen shots??Edit - typo!Terry-- Procrastinate now! |
 |
|
|
JohnBGood
Starting Member
48 Posts |
Posted - 2009-12-22 : 18:53:16
|
| here is the script that I'm using:RESTORE DATABASE ARTEMPR_121409 FROM DISK = 'C:\Documents and Settings\Administrator\Desktop\MTBank\ARTEMPR_121409.bak'With replaceand the error is...Msg 3183, Level 16, State 2, Line 1RESTORE detected an error on page (0:0) in database "ARTEMPR_121409" as read from the backup set.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Restoring a database