INF: Dump File Size Not Updated During Dump Database

Last reviewed: June 27, 1997
Article ID: Q167607

The information in this article applies to:

Microsoft SQL Server, version 6.5 Service Pack 3

SUMMARY

Starting with SQL Server version 6.5 Service Pack 3, during a DUMP DATABASE to a disk file on an NTFS partition, the dump file size is not updated until the end of the dump operation. However, the file size is continuously updated for dumps to files on FAT partitions.

MORE INFORMATION

This is a side effect of SQL Server opening disk dump files with the FILE_FLAG_WRITE_THROUGH flag, which was changed to improve dump performance.

You can monitor dump progress by using the WITH STATS option of DUMP DATABASE. You can indirectly infer the dump file size by monitoring the space available on the disk before starting the dump and then comparing that value to the space available as the dump progresses.

Additional query words: DRC
Keywords : kbusage SSrvGen
Version : 6.5
Platform : WINDOWS

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: June 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.