Step 2. Select Databases to Back Up
At the Databases step of the wizard, select Microsoft SQL Server databases that you want to back up:
- From the Instance drop-down list, select the Microsoft SQL Server instance whose databases you want to back up.
- In the Databases section, select check boxes next to the necessary databases. Alternatively, if you want to back up all databases of the selected instance, select the check box next to the Database Name column name.
To quickly find the necessary databases, you can type the name of the database in the search field and click the search icon.
To refresh the list of databases, click Refresh. When you refresh the list of databases, Veeam Plug-in will clear check boxes next to the selected databases.
- In the Backup set name field, specify the name for the backup set. This will help you identify databases in case you need to restore a database from the backup.
- In the Description field, specify description for the backup set. The name and description of the backup set will be displayed in the Restore Database wizard during restore.
- In the Backup type section, select the type of backup you want to create. You can select from the following native Microsoft SQL Server backup types:
- Full — select this option if you want to create a backup that will contain a full copy of the Microsoft SQL Server database.
- Differential — select this option if you want to create a backup that will contain changes since the previous backup was created.
- Log — select this option if you want to create a backup of Microsoft SQL Server transaction logs.
- If you selected the Full or Log option and want to create a copy-only full backup or copy-only log backup, select the Copy-only backup check box. For example, you may want to create copy-only log backups if you use a separate solution to process Microsoft SQL Server transaction logs.
Keep in mind that differential backups cannot use the copy-only full backup as a starting point. To learn more, see this Microsoft article.
At this step of the wizard, you can also export backup settings to a custom script. You will be able to use this script with a third-party scheduling tool. For details, see Exporting Backup Settings to Custom Script.