Page History

The General tab of the SQL Safe Backup wizard allows you to specify the backup type, name, and description of the backup you are creating.

...

SQL Safe supports the standard SQL Server database backup types:

• Full Backup.
• Differential Backup.
• Transaction Log Backup.
• File Backup.

What should you do for your initial backup?

If you are backing up the database for the first time, select Full Backup. A full backup will provide a comprehensive data set, and is required to perform differential backups or transaction log backups later on. For more information about backup types, Understand backup typesunderstand backup types.

What to choose in the Format drop-down option?

By default, the SQL Safe format is displayed in this option. Backups created using the SQL Safe file format can only be restored by SQL Safe. The SQL Server format is the native SQL Server backup file format. Backups created using the SQL Server format can be restored using SQL Safe and native SQL Server tools.

When should you specify a description?

...

How do you verify the integrity of your backup?

You can choose to verify the backup 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.

...

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.

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

Once you choose your backup type, click NEXT to select the location of your backup files.

...