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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy