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
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
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