September 3, 2001 at 4:29 am
Hi all,
I backed-up (full) a database in one sql server and copied the backed-up file to another sql server machine.
I created a new database and when I tried to restore from the backed-up file, I got the following error
"The backup set holds a backup of a database other than the existing 'databasename' database. Backup or restore operation terminated abnormally"
Can someone say how do I overcome this and do my restoration successfully.
Thanx in advance
Parasu Raman
Regards
Parasu Raman
September 3, 2001 at 10:21 am
Drop the 'new' database you created, then just try doing a restore - specify the dbname when you restore.
Andy
September 3, 2001 at 11:19 pm
Thanx Andy,
When I gave a new db name and tried to restore, it says -
"The file d:\mssql7\data\wodlee_log.ldf' cannot be used by RESTORE. Consider using WITH MOVE option to ...."
What is this new error???
Thanx again
Parasu Raman
Edited by - parasu on 09/03/2001 11:22:05 PM
Regards
Parasu Raman
September 3, 2001 at 11:29 pm
Hi,
I found the problem. There was already a .mdf file with the same name. Now its working fine
Thanx anway
Parasu Raman
Regards
Parasu Raman
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply