Secondary in Loadind mode post role reversal

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  June 12, 2006 at 1:42 pm

  #62404

  I performed a role reversal and the secondary database (old primary) is now in loading phase. I wonder what steps can i take to rectify this problem.

  During reversal I modified the terminated and set it to 0 instead of 1 (default and sets db to singleuser) for the step 2

  EXEC sp_change_secondary_role

      @db_name = 'current_secondary_dbname',

      @do_load = 1,

      @force_load = 1,

      @final_state = 1,

      @access_level = 1,

      @terminate = 1,

      @stopat = NULL

  GO

  I am following microsoft's guidelines for the role reversal

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_1_013_9t0p.asp

   

  any idea?

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  June 12, 2006 at 1:43 pm

  #643225

  Also I dont see a log shipping monitor on my monitoring instance.