If I do a test failover from my primary to the secondary, can I just take a tail log backup of the secondary and restore that to the primary without a full backup restore?
asked Nov 30, 2009 at 08:09 PM in Default
Steve Jones - Editor ♦♦
The way I do it is like this (having suspended the log shipping first, of course):
Before failing over, backup the primary database's log and put the database in standby mode:
Bring the standby on-line by restoring that backup and recovering the database:
The databases are now in the same state and the standby is ready for use. After testing, reverse the process to fail back.
answered Dec 01, 2009 at 11:05 AM