Knowledge Base

INF: Dump File Size Not Updated During Dump Database

Article ID: 167607

Article Last Modified on 2/22/2005

APPLIES TO

This article was previously published under Q167607

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 KB167607


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.