question

kartheeksuresh avatar image
kartheeksuresh asked

Transaction log backup restore

I have a database of size 600 GB and we have a weekly backup of size around 500 GB and a latest daily differential backup of size 60 GB and I have 8 log backups, we are restoring the above backups on news server and mistakenly I have restored 5 log backup with recovery and still i need to apply 3 more log files to the database, Is there any way I can make the database to no-recovery with out restoring all the backups as the backup size is huge and it will take time.
backup-restorelog-backupdifferential-backup
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
JohnM avatar image
JohnM answered
No, I am not aware of any way to accomplish this. Once you've specified WITH RECOVERY, the engine will roll forward/back all of the transactions and bring the database online. You won't be able to apply any further backups. Sorry, but I think that you'll have to start over. Hope this helps!
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks John for your reply.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.