Microsoft KB Archive/295306

= BUG: Log Shipping Elements are Missing After You Upgrade from Standard to Enterprise Edition =

Article ID: 295306

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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.

Additional query words: log_shipping_monitor sp_define_log_shipping_monitor 2812

Keywords: kbbug kbpending KB295306

-

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

© Microsoft Corporation. All rights reserved.