INF: Dump File Size Not Updated During Dump Database (167607)


The information in this article applies to:

  • Microsoft SQL Server 6.5 Service Pack 3 and later
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.
Modification Type:MinorLast Reviewed:2/22/2005
Keywords:kbusage KB167607
©2004 Microsoft Corporation. All rights reserved.