Guys,

When I ran this procedure (sp_change_secondary_role), I would get this
error below:

Server: Msg 14442, Level 16, State 1, Procedure sp_change_monitor_role,
Line 30
Role change failed.


Anyways, I follow Microsoft KB Q294397 by placing terminate = 0.


EXEC sp_change_secondary_role
@db_name = 'Mydb1',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 0,
@stopat = NULL
GO

I would get a message below that seems to be ok, but when I look at my
actual database, it is showing as "Loading" The only time I can get it
to appear normal is to go into All Tasks and do a restore database. Is
this a normal step to promote the secondary server? Nothing in the
technical paper mention it.


Deleting database file 'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\Mydb1_200604200950.tuf'.
RESTORE DATABASE successfully processed 0 pages in 0.105 seconds (0.000
MB/sec).




Any help is appreciated.

Thanks,
Tony

Please ignore this message.


Thanks,
Tony