Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2012-09-12 : 12:53:45
|
| 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 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-12 : 13:17:49
|
| Are you backing them all up at the same time, or serially? When you backup with compression, SQL Server preallocates a file of approximately 1/3rd the size of the database. What are the sizes of all of the databases? If the preallocation is indeed your problem, you could use trace flag 3042 to eliminate that behavior and just have it allocate space as it is backing up.-Chad |
 |
|
|
|
|
|
SQL Server 2008 Enterprise Backup Compression???