Finding backup file size in advance

  • Hi,

    My backups are failing sometimes.

    My db size is around 400 GB and we are taking backup to the remote server. Free size available on the disk is showing 600 GB but my database full backup run more than 10 hrs and failed. The failure reason is there is not enough space on the disk.

    What could be the possible failure reasons? It has more than the the database size on the backup server but why it is showed that msg on the job failures. I noticed same thing occurred couple of times in the past

    Is there any way to find how much the backup file will be generate before we run the backup job?

    i.e. If we run the full backup of test1 database now, it will generate ....bak file for that test1 db

    currently we are using maintenance plan and with compression (2008R2) and the database has TDE enabled

  • if you are using Maintenance plan, one point you will have 2 backup files around 800 GB. you need more than 800 GB to take backup thru MP.

    Right now, delete old backup and run the job again, your job will succeed.

  • Hi Tac,

    other than the old backup it has free space 600GB

  • a few things -

    with TDE enabled you will get very little compression in your backups.

    The size of the backup (leaving out any compression) will be equal to the space used within the database + the size of the active part of the log. So if the backup is larger than the size of the data file there is likely to be a large transaction spanning the time of the backup, so a large amount of log will be required in order for a restore to bring the database to a consistent state.

    ---------------------------------------------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply