INF: Dump File Size Not Updated During Dump Database

ID: Q167607

The information in this article applies to:

Microsoft SQL Server version 6.5 Service Pack 3 and later

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
Issue type :