Deepak Kumar
asked on
Steps for fail over log shipping database from primary to secondary during DR drill and switch back
Hi there,
Could anyone share the steps involved during DR drill for failing over the log shipped databases and app team is gonna do some tests on the secondary database(which will become primary after faiover) then switch it back to the original stake after testing(ie., secondary will again goes to standy/read only) and primary will become active with the logs should resume its syn up job.
Please note, I am running MS SQL Server 2008 R2 enterprise edition on both the servers.
thanks
Deepak
Could anyone share the steps involved during DR drill for failing over the log shipped databases and app team is gonna do some tests on the secondary database(which will become primary after faiover) then switch it back to the original stake after testing(ie., secondary will again goes to standy/read only) and primary will become active with the logs should resume its syn up job.
Please note, I am running MS SQL Server 2008 R2 enterprise edition on both the servers.
thanks
Deepak
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER