Database Engine
1. Backup information
- Title: Will help to identify the task
- Description: Will be the Tooltip (help) to the task
2. Backup type:
- It is possible to choose between four different backup types:
- Full: A data backup that contains all the data in a specific database or set of filegroups or files, and also enough log to allow for recovering that data (*)
- Differential: A data backup that is based on the latest full backup of a complete or partial database or a set of data files or filegroups (the differential base) and that contains only the data extents that have changed since the differential base. A differential partial backup records only the data extents that have changed in the filegroups since the previous partial backup, known as the base for the differential (*)
- Transaction log: A backup of transaction logs that includes all log records that were not backed up in a previous log backup. (full recovery model) (*)
- Remote (Script): A backup that makes a dump of the database that includes the schema and the INSERT statements to load the data into the database
3. Compression: (ǂ)
- Use MS SQL Server Backup Compression: Since MS SQL Server ® 2008, Microsoft introduces the capability of compress natively the backup. Not all the editions support this option. I suggest always check this feature, if it is not available doesn't matter, because SQLServerBooster internally always check it before apply. If you want to know more about this feature read this article in MSDN
- Compression level: It is possible select between three compression levels. While higher the level more CPU is demanded
- Encrypt backup: It is possible select between Standard, AES128, AES192 and AES256
- Split backup file: It is possible to split the compressed files into multiple files
- Delete backup after compress: Deletes the backup after being compressed
Analysis Services
1. Backup information
- Title: Will help to identify the task
- Description: Will be the Tooltip (help) to the task
2. Compression: (^)(ǂ)
- Use MS SQL Server Compression: It is possible to compress the SSAS databases natively by MS SQL Server. If you want to know more about this feature read this article in MSDN
- Compression level: It is possible select between three compression levels. While higher the level more CPU is demanded
- Encrypt backup: It is possible select between Standard, AES128, AES192 and AES256
- Split backup file: It is possible to split the compressed files into multiple files
- Delete backup after compress: Deletes the backup after being compressed
(^) Note: Backup "SSAS Remote Partitions" are not supported in this version.
(ǂ) Note: If the backup is not compressed then it won't be able to upload to the Cloud (Amazon S3, Amazon Glacier, Windows Azure or Dropbox) or send through FTP.
Next: Choose the backup type and make another copies
(*) Source Technet Microsoft
