PRB: Database Loaded in Standby Mode if No Recovery Mode is Selected from Destination Database Window When You Configure Log Shipping (301049)


The information in this article applies to:

  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Evaluation Edition
  • Microsoft SQL Server 2000 Developer Edition
This article was previously published under Q301049

SYMPTOMS

When you configure Log Shipping through the SQL Server Enterprise Manager Database Maintenance Plan wizard, if you select NORECOVERY mode in the Add Destination Database dialog box, the database is loaded in STANDBY mode.

The recovery status of this database is reverted to NORECOVERY after the first transaction log backup is applied by the Log Shipping schedule.

WORKAROUND

The database recovery status is changed to LOADING after the application of the first transaction log backup. No action is required by the user.

MORE INFORMATION

If you require the database to be in a NORECOVERY state (on the secondary server) before the application of the first transaction log backup, use these steps:
  1. Perform a complete database backup of the source database on the primary server.
  2. Restore this complete backup on the secondary server in NORECOVERY state.
  3. Select the Use Existing Database option in the Add Destination Database dialog box when you set up Log Shipping.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbpending kbprb KB301049
©2004 Microsoft Corporation. All rights reserved.