Microsoft KB Archive/167607

= INF: Dump File Size Not Updated During Dump Database =

Article ID: 167607

Article Last Modified on 2/22/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Service Pack 3

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.