log shipping switchover and switchback

• coolchaitu

  SSChampion

  Points: 10334

  More actions

  July 12, 2024 at 5:10 pm

  #4435619

  I have log shipping in my environment. Could you please let me know steps to switchover and switchback for doing DR  drill

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  July 13, 2024 at 6:10 pm

  #4435874

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  July 15, 2024 at 5:52 pm

  #4436289

  MSFT have a doc with the steps on that topic.

  https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/fail-over-to-a-log-shipping-secondary-sql-server?view=sql-server-ver16#see-also

  Let us know is you need any further clarification.