Redstor's Enterprise Server Edition (ESE) backup client can backup Microsoft SQL Server databases using Virtual Shadow Copy (VSS). As with backing up open/locked files, VSS takes a snapshot which is then used by the backup client instead of live data files.
To make a backup selection of SQL databases, open the backup client and click the SQL button to the left. The databases will be shown in the format SQL > Server Name > Instance Name > Database Name. You can have multiple instances, each with multiple databases, as seen below.
Backup inclusions/exclusions can be made at any level of the tree structure by right-click the object and choosing Include or Exclude. This action is inherited, i.e. it is applied to any object below the level where the action is being applied.
If you have Full System Backup enabled, all the databases will be included in the backup selection by default. If you don’t wish to backup a specific database, you can apply a manual exclusion.
If SQL Server is installed on your machine but there is no SQL button in your backup client, this may be because
- the SQL VSS Writer Service is not running,
- a database on a local SQL Server instance has a preceding or trailing space, or
- a service logon user doesn’t have sysadmin privileges.
If you encounter other issues with backing up SQL databases, see Common VSS error messages and troubleshooting.
- Databases that are detached from the SQL Server instance will not be displayed in the SQL tree view and will need to be backed up from the Files and Folders view.
- If you select a SQL database in both the SQL tree view and the Files and Folders view, only one copy of the database will be backed up.