In this article, we will see how to do Database Backup Compression in SQL Server.
In this article, we will see how to do Database Backup Compression in SQL Server 2012. To do that you can use SQL Server Management Studio and also you can use a Transact-SQL statement. So let's have a look at a practical example of how to do database backup with compression. The example is developed in SQL Server 2012 using the SQL Server Management Studio.
To visually create a Database Backup
Now Press F8 to open the Object Browser in SQL Server Management Studio and expend it.
Select database then right-click on the selected database then click on "Task" then click on "Back Up".
This will open the following window:
To specify the destination of the database, select the destination then click on the Add Button. We then see a new dialog box, click on the browse button to choose the location.
Now next click on "Options" and the following screen appears:
Now select Compress Backup.
The above image contains three options to select:
Now click again on the "General" option.
Now you will see that the database backup has completed successfully.
Now click on the OK Button. The database backup file has been created to the given location.
Functions in SQL Server: Practical Guide