March 8, 2015 at 7:18 pm
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
March 9, 2015 at 6:34 am
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.
March 9, 2015 at 6:45 am
Hi Tac,
other than the old backup it has free space 600GB
March 9, 2015 at 7:44 am
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