A snapshot-based database backup restore process may fail, and you may receive an error message in SQL Server 2005 (915385)

The information in this article applies to:

Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
Microsoft SQL Server 2005 Enterprise X64 Edition
Microsoft SQL Server 2005 Express Edition
Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Standard X64 Edition
Microsoft SQL Server 2005 Workgroup
SQL Server 2005 Standard Edition for Itanium-based Systems

Bug #427793 (SQLBUDT)

SYMPTOMS

When you try to restore a snapshot-based database backup from a file or from a file group in Microsoft SQL Server 2005, the restore process may fail. Additionally, you may receive one or more of the following error messages:

Error message 1

Successfully completed data transfer.

Error message 2

Msg 3283, SevLevel 16, State 1 The file "MyDBLog" failed to initialize correctly. Examine the error logs for more details.

Error message 3

Msg 3013, SevLevel 16, State 1 RESTORE DATABASE is terminating abnormally.

Error message 4

Errors resulted in failure of the command

CAUSE

This issue occurs because of a change in SQL Server 2005.

SQL Server 2000 required the following multiple-step restore process:

Restore the file or the file group from the full database backup. The database remains in a restoring state.
Restore the transaction log or logs from the log backup chain.

SQL Server 2005 tries to restore the log files and the data files in a single step. Some third-party snapshot backup utilities do not support the single-step approach.

WORKAROUND

To work around this issue, use one of the following methods:

Use the WITH NO_LOG clause during the restore process.
Restore a full database backup instead of a file subset.
Use trace flag 3117. This trace flag tells SQL Server 2005 to use the SQL Server 2000 behavior.

Modification Type:	Major	Last Reviewed:	6/12/2006
Keywords:	kbsql2005engine kbExpertiseInter kbExpertiseAdvanced kbtshoot kbinfo KB915385 kbAudDeveloper kbAudITPRO