February 19, 2013 at 4:47 pm
I have restored a database to a new name. The original name is forms. The new database is forms_scott(Restoring). When I try to restore a log:
RESTORE LOG [forms_scott] FROM DISK = N'D:\sqlbackups\forms\Forms_backup_2013_02_17_130013_8884015.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10
GO
I get:
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'forms_scott' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
How can I restore a log to a new db name?
February 20, 2013 at 1:33 am
That should work... are you sure the transaction log backup file actually has a backup of the original forms database?
Run a restore of the log with headeronly to verify.
RESTORE HEADERONLY FROM DISK = N'D:\sqlbackups\forms\Forms_backup_2013_02_17_130013_8884015.trn'
February 20, 2013 at 6:42 am
Did you restore over an existing database without using the overwrite flag?
February 20, 2013 at 8:00 am
No, I am trying to restore to a new database name while the existing one stays in place.
I ended up having him restore the database to another server with the original name and then I am restoring the logs. Of course, now he keeps putting it in recovery mode, so I cannot do logs. Hopefully, we'll get where I can restore some logs...
When he did the restore originally, the database had next to it something like "restoring..." instead of the "recovering...". Thus, I Don't think he did the right type of restore.
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