Microsoft KB Archive/915385

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

Article ID: 915385

Article Last Modified on 11/20/2007

-

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 Edition
 * Microsoft 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 &quot;MyDBLog&quot; 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.

Keywords: kbinfo kbtshoot kbexpertiseadvanced kbexpertiseinter kbsql2005engine KB915385

-

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

© Microsoft Corporation. All rights reserved.