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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply