August 21, 2007 at 12:06 am
hi,
can somebody pls. guide me how to restore the database backup when server name is changed.
when i kept the backup of my database my sql server name was "abc" and now when i want to restore the backup of my database my sql server name is "xyz1".
when i try to restore the backup, sql server gives an error:
"The backup set holds a backup of a database other than existing database"
Whereas the database name is exactly the same as previous.
Thanks,
Harry
August 21, 2007 at 12:53 am
hi
check the file path of the mdf and ldf files of the database on which you are performing the restore (in the options page).
did u check the overwrite database check box.
"Keep Trying"
August 22, 2007 at 6:27 am
Here is the T-SQL for this RESTORE DATABASE NORTH
FROM DISK = 'C:\SQL\Backup\North.bak'
WITH MOVE 'NORTH_Data' TO 'D:\SQL\Data\North_Data.mdf',
MOVE 'NORTH_Log' TO 'E:\SQL\Log\North_Log.ldf'
For dull disclosure I copied this from this article: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1102260,00.html
I usually use EM or SSMS to do restores and checking the overwrite is what you need to do.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 22, 2007 at 7:12 am
Might want to restore the filelist to see that you had backed up what you wanted
restore filelistonly from <backup file/device>
August 22, 2007 at 7:14 am
The RESTORE DATABASE needs the parameter REPLACE to 'overwrite' an existing DB.
August 23, 2007 at 11:54 pm
Hi
Pls try to attached the database rather than restoring it
it will work i tried it
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply