How to change the standby server to online when I am running LogShipping

• MAK-1128556

  SSCarpal Tunnel

  Points: 4594

  More actions

  December 17, 2009 at 12:22 pm

  #139998

  I am running logshipping on SQL 2005 in one database, but now I need secoundary server to be a primary server

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  December 17, 2009 at 12:35 pm

  #1093701

  This might get you headed in the right direction:

  http://deepakrangarajan.blogspot.com/2007/06/role-change-in-sl-2005-log-shipping.html

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events