SQL Server Performance Forum – Threads Archive

LogShipping Change Secondary Role

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.

---

Refer to thishttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2314 post to resolve the issue. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>