You cannot back up a volume by using the Volume Shadow Copy Service in Windows Server 2003 after you install Microsoft SQL Server 2005 CTP (904801)



The information in this article applies to:

  • Microsoft SQL Server 2005 Developer Edition Community Technology Preview
  • Microsoft SQL Server 2005 Enterprise Edition Community Technology Preview
  • Microsoft SQL Server 2005 Standard Edition Community Technology Preview

BUG #: 374228 (SQLBUDT)

Beta Information

This article discusses a Beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this Beta product. For information about how to obtain support for a Beta release, see the documentation that is included with the Beta product files, or check the Web location where you downloaded the release.

SYMPTOMS

Consider the following scenario. You install Microsoft SQL Server 2005 Community Technology Preview (CTP) on a computer that is running Microsoft Windows Server 2003. Then, you try to back up data from a volume by using the Volume Shadow Copy Service (VSS). Under these conditions, you may receive the following error message:
Error returned while the creating volume shadow copy: 80042301
Additionally, you may find that the VSS has stopped and that you cannot restart the service.

This issue only occurs in versions of Microsoft SQL Server 2005 CTP earlier than build 09.00.1178.01.

Note If you are currently experiencing this issue, and you are running a version of SQL Server 2005 CTP that is earlier than build 09.00.1178.01, you cannot resolve this issue by applying the latest build of SQL Server 2005 CTP.

If you have not installed any version of SQL Server 2005 CTP, and you install build 09.00.1178.01 or a later version of SQL Server 2005 CTP, you will not experience this issue.

CAUSE

This issue occurs because the Setup program for SQL Server 2005 CTP leaves an invalid registry entry under the follow subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl

The invalid registry entry has no value.

WORKAROUND

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To work around this issue, follow these steps:
  1. Start Registry Editor.
  2. Locate and then click the following key in the registry:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl

  3. Right-click the VssAccessControl key, and then click Delete.
  4. Quit Registry Editor.
Note After you delete the registry key, you must make sure that the startup account of the SQL Writer Service is running as an Administrators account or as a Backup Operators account.

REFERENCES

For more information, visit the following Microsoft Developer Network (MSDN) Web site:

Modification Type:MinorLast Reviewed:3/11/2006
Keywords:kbtshoot kberrmsg kbprb KB904801 kbAudDeveloper