Sp_change_secondary_role Problems

Jul 20, 2005

primary server is unavailable, I couldn't able to demote the
primary server. I ran this query to promote secondary server. I've
tried with different options @terminate=0. I've ensured no user
connections exist. But still getting sqlmint.exe error. Any one
experienced this problem? I've checked KB article, but still not
working

EXEC msdb.dbo.sp_change_secondary_role
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replication = 0,
@stopat = null

View 4 Replies


ADVERTISEMENT

Sp_change_secondary_role Missing In SQL Server 2005?

Jul 25, 2006

I've got SQL Server 2005 Ent Ed 9.0.1399 and want to change mysecondary Log Shipping server into a primary. I've tried locating thesp_change_secondary_role, but can't seem to find it. Has it beenreplaced with another stored procedure? If so, which are the proceduresto run?On SQL Server 2000, the following were the steps listed:1. Transfer logins2. Run sp_change_primary_role3. Run sp_change_secondary_role4. Run sp_change_monitor_role (this exists in SQL Server 2005)5. Run sp_resolve_logins3 & 5 are what I'd expect to perform if the primary isn't available.N.I.T.I.N.

View 1 Replies View Related

SQL Server 2005 - Log Shipping - Missing Sp_change_primary_role And Sp_change_secondary_role

Dec 14, 2006

I have installed SQL Server 2005 and setup a cluster and log shipping. I decided to perform a planned failover and realized that there are no sp_change_primary_role and sp_change_secondary_role stored procedures. I checked on both the SQL Server 2005 installations and could not find them.

My question is :

"Is it safe to get these stored procedures from a SQL Server 2000 database and run them on the SQL Server 2005 database ??"

"Has anyone come across such missing stored procedures in SQL Server 2005 and know the reason why it is so (so that I can avoid it in the future if it due to a faulty installation) ?"

Cheers
NEVILLE GEORGE

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved