Creating compressed DB backups on v9

To enable compression by default on SQL Server:

1. Go to SQL Server Management Studio and log on
2. In the Object Explorer, right-click on the Server and select Properties
3. Click on Database Settings
4. 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 :

How to schedule Automatic Backup in 9version.

Another good option is using only the SSMS. Here is how to do it:

SQL 2012 Scheduling Auto Backup – CodeProject