SQL Server Performance

LogShipping Change Secondary Role

Discussion in 'SQL Server Log Shipping' started by tapansarkar, Feb 18, 2004.

  1. tapansarkar New Member

    Whenever I am trying to put my secondary server operational as my primary (primary is not available) by running
    sp_change_secondary_role
    @db_name = 'TX_ACCOUNT',
    @final_State = 1,
    @access_level = 1,
    @terminate = 1

    I am repeatedly getting this message

    Server: Msg 3021, Level 16, State 1, Procedure sp_change_secondary_role, Line 124
    Cannot perform a backup or restore operation within a transaction.
    Server: Msg 3013, Level 16, State 1, Procedure sp_change_secondary_role, Line 124
    RESTORE DATABASE is terminating abnormally.
    Server: Msg 226, Level 16, State 1, Line 1
    ALTER DATABASE statement not allowed within multi-statement transaction.


  2. satya Moderator

Share This Page