Protect All Your Systems. How do I backup and restore the database? How to backup your database?
Therefore, by default, when backing up a database using compression , the Database Engine uses a pre-allocation algorithm for the backup file. This algorithm pre-allocates a predefined percentage of the size of the database for the backup file. If more space is needed during the backup operation, the Database Engine grows the file. Backs up a SQL database. Click one of the following tabs for the syntax, arguments, remarks, permissions, and examples for a particular SQL version with which you are working.
The power of this feature is to both speed up the backup process, and to save disk space. Our example was the easiest and you can see from the backup sizes that this has got us times disk compression. This is a powerful and lesser appreciated feature when it comes to working with SQL Server. This simply shows Compression is not supported on MSSQL Web Edition. When we install SQL Server, by default this option is turned off.
The only real downsize of the compressed backup with SQL is that the file cannot be optimally compressed further with other utilities. For example a normal database (no jpgs, etc, just basic data types) with a backup of GB: - SQL compression backup is 2.



