Posted by NiTiN on 07/25/06 06:42

I've got SQL Server 2005 Ent Ed 9.0.1399 and want to change my
secondary Log Shipping server into a primary. I've tried locating the
sp_change_secondary_role, but can't seem to find it. Has it been
replaced with another stored procedure? If so, which are the procedures
to run?

On SQL Server 2000, the following were the steps listed:
1. Transfer logins
2. Run sp_change_primary_role
3. Run sp_change_secondary_role
4. Run sp_change_monitor_role (this exists in SQL Server 2005)
5. Run sp_resolve_logins

3 & 5 are what I'd expect to perform if the primary isn't available.

N.I.T.I.N.

[Back to original message]