Known Issue In Cumulative Updates For SQL Server 2005 SP2, SP3 & 2008 RTM, SP1 When restoring SQL Server 2000 DB Through Management Studio

Customers using SQL Server 2005 or 2008 Management Studio to restore a SQL Server 2000 Database backup will most likely see the error message as described in KB 972687. This KB article provides details of available workarounds and information about hotfix packages which rectify the issue as they become available. We anticipate having hotfix packages for SQL Server 2008 RTM & SP1 available by mid next week. For SQL Server 2005 SP2 we anticipate releasing the fix in the next Cumulative Update. These packages can be identified with “CU_Updated_Ref_KB_972687” in the package name. These packages do not replace the existing Cumulative Update packages.

Customers who do not intend to restore SQL Server 2000 databases from SQL Server 2005 or 2008 Management Studio are not affected by this issue and may continue to use the hotfix packages as released.

Affected Products:

· SQL Server 2005 SP2 Cumulative Update 13 & Cumulative Update 14

· SQL Server 2005 SP3 Cumulative Update 3 & Cumulative Update 4

· SQL Server 2008 RTM Cumulative Update 5 & Cumulative Update 6

· SQL Server 2008 SP1 Cumulative Update 2 & SQL Server 2008 SP1 Cumulative Update 3

· Build number ranges below.

Affected Build Range

Customers with ...

· SQL Server 2005 SP2 Management Studio with version between 9.00.3325 and 9.00.3329

· SQL Server 2005 SP3 Management Studio with version between 9.00.4220 and 9.00.4228

· SQL Server 2008 RTM Management Studio with version between 10.00.1806 and 10.00.1813

· SQL Server 2008 SP1 Management Studio with version between 10.00.2714 and 10.00.2725

To determine the current version of SQL Server Management Studio select "About ..." from the Help menu inside Management Studio.

Abhishek Sinha

Program Manager

SQL Server Sustained Engineering