Microsoft KB Archive/196658

= INF: Differential Backup Time Considerations =

Article ID: 196658

Article Last Modified on 10/27/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q196658



SUMMARY
A differential backup only records changes made to the database since the last full backup was made. While typically much faster than a full database backup, elapsed time for SQL Server 7.0 differential backup is roughly proportional to the allocated space in the database. Consequently, a differential backup on a very large database may take longer than expected, even if few changes have occurred since the last full database backup.

If the amount of time required for a differential backup is too large, you should consider doing log backups instead.

Additional query words: back up diff

Keywords: kbinfo KB196658

-

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

© Microsoft Corporation. All rights reserved.