Logshipping Query
-
Logshipping is out of sync for 2 days and so i have a huge amount of logfiles to copy and restore to DR Server.Is there any way by which i can reduce my time of restoring all these logfiles and instead do something by which my logshipping can start without restoring all the logfiles one by one.
-
How often do you do FULL backups?
-
mahesh.dasoni (1/11/2013)
Logshipping is out of sync for 2 days and so i have a huge amount of logfiles to copy and restore to DR Server.Is there any way by which i can reduce my time of restoring all these logfiles and instead do something by which my logshipping can start without restoring all the logfiles one by one.i can smell that its again interview question ? anyways restore latest backup would be easier and appropriate approach here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
If you have not taken a full backup on the primary since log shipping became out-of-sync then you can bring the secondary up to date and resuming the existing log shipping configuration by taking a differential backup from the primary and restoring it on the secondary. If you have taken a full backup from the primary since log shipping went out-of-sync then you will need to re-initialize log shipping from a full backup.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato -
Opc is right about the differential backup. About restoring the full backup. If the size of the DB is big and if you have all transaction logs I will probably copy all the transaction logs and start the restore job. If restoring the differential is an option I'll will chose that one for sure.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply