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_secon dary_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_prima ry_role
3. Run sp_change_secon dary_role
4. Run sp_change_monit or_role (this exists in SQL Server 2005)
5. Run sp_resolve_logi ns
3 & 5 are what I'd expect to perform if the primary isn't available.
N.I.T.I.N.