Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
booyeeka
Starting Member
10 Posts |
 Posted - 2008-03-18 : 20:52:54
|
| hi all!i'm following instructions from MS SQLServer Administrator student's documentation.i can not finish creation of the standby server.i can not execute SP that have to update information stored on monitor server with new roles.i'm using next statement on standby server:EXEC msdb.dbo.sp_change_monitor_role 'winxp', 'winxp\newinstance', 'northwindlogship', 'c:\productionLogs' all the time i got following error:Server: Msg 14442, Level 16, State 1, Procedure sp_change_monitor_role, Line 30Role change failed.i have tryed everything, but everytime i got this error message.can you help me how to solve this?thank you 10000x in advance!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-18 : 21:51:20
|
| Why is this urgent?I never got the role change to work, so we switch roles manually.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
booyeeka
Starting Member
10 Posts |
Posted - 2008-03-19 : 03:13:00
|
| for me is urgent, because i must configure proper logshipping today:-( |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-19 : 15:02:45
|
| You don't need the role change to setup log shipping.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Role change failed (logshipping)