Jai-SQL DBA (9/26/2012)
Hi,I want to understand the Logshipping reestablishment Scenerio After a Failover.Below Mentioned are the details of the Environment for the Better Understanding.
Server A: Primary Server
Server B: Secondary Server
Logshipping established between A and B .
Server A Crashed.I have restored all the Pending Logs to Secondary Server and got it into a Consistent State and Its in Use from last few days .
Did you backup the tail of the log on the original primary and restore this?
Jai-SQL DBA (9/26/2012)
1.Can i just restore the Full Backup of Server B on Server A and change the Mode of B to no recovery(Standby/Readonly) and Reconfigure the LOGSHIPPING from A to B.Will that Work ??
2.Do I need to restore the Full Backup on Server A and then take a backup from A to B restoring a no recovery(Standby/Readonly) and Reconfigure the LOGSHIPPING from A to B.
What is your Opinion on the above two Doubts .Please Advise
You shouldn't need to restore any full backups if you made the switch correctly!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉