jjohnsqldba (9/7/2012)
Hi,We have a log-shipping set up on the production server for reporting purpose.
Unknowingly, I have set up a backup strategy which also includes trans-log backups.
So, my log-shipping failed. Restoration job on the second server failed.
Is there any way I can get back the secondary database on Server2.
Secondary Database is in (StandBy mode/Readonly)
Can anyone help me getting back my secondary server database back?
(I will be getting a daily full back up at 12AM and Tran-log backup for every hour)
If you want to get your Log Shipping back and Running you may need to restore a Full backup again. In case you have all the transaction log backups from the moment your Secondary run out of synch, you can try restoring all the transaction log backups from your backup strategy combined with the log backups from Log Shipping. You should consider taking the transaction log backups out of your backup strategy and use the transaction log backups from Log Shipping. By using both you will need both log backups in case of a disaster (the ones from your backup strategy and the ones from Log Shipping).
Why would you like to backup the secondary database?
