Post reply

SQL Server 2008 Enterprise Backup Compression???

  • September 12, 2012 at 10:52 am

    #281288

    Hello -

    I have a database that is 124 GB before backup compression is applied. I also have other databases that after compression is applied during backup comes to a total of 16GB. The drive is only 136GB in size hence why I want to compress that database backup.

    I have tested and ran the backup on the 124 GB database and its gets compressed to 64 GB.

    There is 115 GB free after all the other databases backup and are compressed. When then can't the 124 GB which compresses down to 64GB not get backed up?

    Regards,

    David

  • September 12, 2012 at 11:00 am

    #1536848

    Here is my guess based on experiences at Progressive. SQL Server is preallocating space for the backup and estimates how much space it needs. Apparently, and this is a guess, this estimate either larger than 115 GB or the disk is fragmented enough that it can't get enough space for the file. I tend to lean to the former more than the latter.

Viewing 2 posts - 1 through 2 (of 2 total)

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