Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: role change

Role Change in SQL 2005 Log Shipping

In SQL 2000 where the role change was relatively easy through the use of stored procedures, unfortunately in SQL 2005 those SPs are no longer used and we have to perform the following steps to sync the secondary server with primary and then failover.

Published July 22, 2007
Categorized as High Availability Tagged log shipping, role change

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.