Microsoft KB Archive/311177

= Log Shipping Monitor out-of-synchronization messages are incorrectly raised in an outage period in Microsoft SQL Server 2000 Enterprise Edition =

Article ID: 311177

Article Last Modified on 12/27/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition

-



This article was previously published under Q311177





SYMPTOMS
Log Shipping Monitor out-of-synchronization messages are incorrectly raised in an outage period. After you set up log shipping in Microsoft SQL Server 2000 Enterprise Edition, you can specify an outage period in the Suppress Alert Generation pane. The Suppress Alert Generation pane is in the Log Shipping Pair Properties dialog box. When you specify an outage period to suppress Log Shipping Monitor out-of-synchronization messages, out-of-synchronization messages may still be raised in that outage period.



CAUSE
The problem occurs because Log Shipping Monitor incorrectly calculates the outage period.



WORKAROUND
To work around this problem, use one of the following methods:  Method 1

Let Log Shipping Monitor run through the outage period. Then, do not set an outage period for out-of-synchronization messages. Method 2

Add a SQL Server Agent job to disable out-of-synchronization messages and then to enable out-of-synchronization messages for the outage period. To do this, follow these steps:  Start SQL Server Enterprise Manager. Connect to the server that is configured as Log Shipping Monitor. Expand Management, expand SQL Server Agent, and then click Jobs. Add a SQL Server Agent job to disable out-of-synchronization messages. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Right-click Jobs, and then click New Job.</li> In the Name box, type, and then click the Steps tab.

Note The placeholder  is the name of the job that disables out-of-synchronization messages.</li> On the Steps tab, click New, and then type  in the Step name box.

Note The placeholder  is the name of the step that disables out-of-synchronization messages.</li> In the Type box, click Transact SQL Script (TSQL).</li>  Put the following Transact SQL code example in the Command box, and then click OK. EXEC msdb..sp_update_log_shipping_monitor_info @primary_server_name='<primaryServerName>', @primary_database_name='<primaryDatabaseName>', @secondary_server_name='<secondaryServerName>', @secondary_database_name='<secondaryDatabaseName>', @backup_threshold_alert_enabled=0, @out_of_sync_threshold_alert_enabled=0 </li> Click the Schedules tab, and then click New Schedule.</li> In the Name box, type, and then click Change.

Note The placeholder  is the name of the schedule that disables out-of-synchronization messages.</li> In the Edit Recurring Job Schedule dialog box, enter the starting time that you want to disable out-of-synchronization messages, and then click OK.</li> Click OK two times to close the Job Properties dialog box.</li></ol> </li> Add a SQL Server Agent job to enable out-of-synchronization messages. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Right-click Jobs, and then click New Job.</li> In the Name box, type  and then click the Steps tab.

Note The placeholder  is the name of the job that enables out-of-synchronization messages.</li> On the Steps tab, click New, and then type  in the Step name box.

Note The placeholder  is the name of the step that enables out-of-synchronization messages.</li> In the Type box, click Transact SQL Script (TSQL).</li>  Put the following Transact SQL code example in the Command box, and then click OK. EXEC msdb..sp_update_log_shipping_monitor_info @primary_server_name='<primaryServerName>', @primary_database_name='<primaryDatabaseName>', @secondary_server_name='<secondaryServerName>', @secondary_database_name='<secondaryDatabaseName>', @backup_threshold_alert_enabled=1, @out_of_sync_threshold_alert_enabled=1 </li> <li>Click the Schedules tab, and then click New Schedule.</li> <li>In the Name box, type, and then click Change.

Note The placeholder  is the name of the schedule that enables out-of-synchronization messages.</li> <li>In the Edit Recurring Job Schedule dialog box, enter the starting time that you want to enable out-of-synchronization messages, and then click OK.</li> <li>Click OK two times to close the Job Properties dialog box.</li></ol> </li></ol> </li></ul>

Note You must follow these steps for every Log shipping database that is configured with an outage period for out-of-synchronization messages.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
For additional information about log shipping in SQL Server 2000, visit the following Microsoft Developer Network (MSDN) Web sites:

Log shipping in SQL Server 2000

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/LogShippinginSQLServer2000.asp

Log shipping in SQL Server 2000, part 2

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag02/html/LogShippinginSQLServer2000Part2.asp

Keywords: kbtshoot kbbug kbprb kbpending KB311177

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.