BUG: Log Shipping Elements are Missing After You Upgrade from Standard to Enterprise Edition (295306)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q295306
BUG #: 353420 (SHILOH_BUGS)

SYMPTOMS

After you upgrade to SQL Server 2000 Enterprise Edition from SQL Server 2000 Standard Edition, some log shipping tables and stored procedures may be missing. This may cause the following errors in two different steps when you run the Database Maintenance wizard to configure log shipping:
Error 208: Invalid Object name msdb.dbo.log_shipping_monitor

-and-

Error 2812 : could not find msdb.dbo.sp_define_log_shipping_monitor

CAUSE

By design, the setup adds no components on a SKU upgrade. The addition of components must be performed after the SKU upgrade. So, during the upgrade process the log shipping installation script will not run.

WORKAROUND

After the upgrade completes, run the log shipping installation script, instls.sql, which is located in the \Install folder of the Enterprise edition CD.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB295306
©2003 Microsoft Corporation. All rights reserved.