Creating compressed DB backups on v9
To enable compression by default on SQL Server:
- Go to SQL Server Management Studio and log on
- In the Object Explorer, right-click on the Server and select Properties
- Click on Database Settings
- Check the Compress backup option. (If left uncheckd, backups won’t be compressed by default).
To configure automatic backups (Schedule and Path) see this document created by Prasanna s :
Another good option is using only the SSMS. Here is how to do it: