The General section of the Backup wizard allows you to specify the backup type, name, and description of the backup you are creating.
What types of backups can you choose?
SQL Safe supports the standard SQL Server database backup types:
- Full
- Differential
- Transaction Log
- File
What should you do for your initial backup?
If you are backing up the database for the first time, select Full. A full backup will provide a comprehensive data set and SQL Safe requires it to perform differential backups or transaction log backups later on. For more information about backup types, go to Understand backup types.
When should you specify a description?
After you specify the name for you backup operation, you should provide a description to identify important details about this operation so you can easily recognize which backup sets should be restored later. The backup description will appear in the status view of past and current backups and will allow you to identify problems when they occur.
What is a copy-only backup?
A copy-only backup is a copy of the database, not a true backup, and cannot be used as a part of a restore strategy or restore chain. It is a backup that does not affect the log sequence numbers (LSN) of the database.
How do you verify the integrity of your backup?
You can choose the option to Verify Backup. When this option is selected, SQL Safe performs a data integrity check after the backup has been created. SQL Safe only verifies the integrity of the data files in the backup set created by this backup.
Verifying the backup helps identify potential issues that could occur when restoring data files.
After choosing your backup type, go to Selecting the location of your backup files.