Is there any 1 click procedure or GUI tool available to reverse the roles in a LiteSpeed 5.x LogShipping Plan?
Currently, there is no one-click procedure to do the failover and failback of LogShipping in LiteSpeed.
To do it manually, Please follow the steps below:
1. Disable the backup job from the publisher, the copy job and restore job from subscriber. Make sure the last backup is completed before get to step 2.
2. Force the copy job to run to copy all the remained transaction from the share directory to the local restore directory on the subscriber server.
3. Manually restore the transaction log to Destination Database on the subscriber with standby option. This will provide the last chance for verification before bringing it up
4. BACKUP the Source Database from the publisher using WITH STANDBY option in NATIVE T-SQL script or @WITH = STANDBY = <path\filename> parameter in LiteSpeed script. Make sure no other user logging on the database. BACKUP with STANDBY or NORECOVERY option need single user access (just like restore). And this will bring the database to STANDBY mode.
5. RESTORE this transaction log to the <LogShippedDatabase> on the subscriber using WITH RECOVERY option in NATIVE T-SQL or @WITH = RECOVERY parameter in LiteSpeed script to bring the <LogShippedDatabase> on subscriber out of standby mode
6. Remove the existing logshipping plan. (best do it from the GUI).
7. Recreate the logshipping plan in the reverse direction.
