Eval Q: Status of % complete of backup

kolsonkolson Posts: 3
edited March 7, 2006 6:49PM in SQL Backup Previous Versions
Is there anywhere in the SQL Backup console that shows what % status completed of the backup?

Comments

  • peteypetey Posts: 2,358 New member
    No. This information isn't readily available from SQL Server. E.g.

    For a full backup, a database that's 100 MB in size may only create a 90 MB backup, if the trx log size is 10 MB in size, all data is committed and the simple recovery model is used.

    For differential and transaction log backups, there isn't an accurate way to tell how much data needs to be backed up.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.