PRB: Dumping to New Dump Device w/ INIT Causes Dbsvolopen Error

 Last reviewed: November 13, 1997
Article ID: Q176726
The information in this article applies to:
  • Microsoft SQL Server, version 6.5

SYMPTOMS

If you create a new disk dump device and then dump to the new disk dump device using the INIT option, a dbsvolopen error may be written to the SQL Server error log.

The dump completes successfully, however, the following entry is written to the error log: 

   97/10/17 11:00:39.73 kernel   dbsvolopen: Backup device
   'C:\MSSQL\BACKUP\rajbak.DAT' failed to open, operating system error =
   2(The system cannot find the file specified.)

CAUSE

Microsoft SQL Enterprise Manager issues a LOAD HEADERONLY statement every time a database dump is initiated with the Initialize Device option selected. This is done to check whether the dump device has previous dumps which might be erased. However, because a new disk dump device does not exist until the first dump is completed, the dbsvolopen error is written into the error log.

WORKAROUND

No action is required. This error message can safely be ignored.

Additional query words: SEM backup
Keywords : SSrvAdmin SSrvEntMan SSrvErr_Log kberrmsg
Version : WinNT:6.5
Platform : NT WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 13, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.