SQL 2008.. Compress them backups
For those SQL admins who have managed their SQL backups using SQL dumps have had to wrestle with file sizes for many years. There are better ways of backing your databases up using things like SQL connectors to a backup software like CommVault or other backup programs but many times you just need a SQL Dump file. Depending on the size of the data in the Database they can be quite large.
The good news is that there is lot of empty space in those files and they compress very well. But the bad news to go with that is if they are larger files you will find yourself having issues with programs like WinZIP.
With SQL 2008 this is no longer an issue because it will perform compression natively during the creation of the SQL dump file. To compress the backup use the following command syntax:
BACKUP DATABASE <database name> TO <backup Device> WITH COMPRESSION
To take that to the next level and set compression on by default for all database dumps execute the following commands:
EXEC sp_configure ’show advanced options’,1
RECONFIGURE
ESEC sp_configure ‘backup compression default’,1
RECONFIGURE
So no more large SQL dump files. As if you needed another reason to upgrade your SQL Servers.
If you found this page useful, consider linking to it.
Simply copy and paste the code below into your web site (Ctrl+C to copy)
It will look like this: SQL 2008.. Compress them backups
Enjoy this post? Please consider leaving a comment or subscribe to the feed and get future articles delivered to your feed reader.
Comments
No comments yet.
Leave a comment