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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply