Selecting SQL databases

Selecting SQL databases

A backup of an SQL database contains the database files (.mdf, .ndf), log files (.ldf), and other associated files. The files are backed with the help of the SQL Writer service. The service must be running at the time that the Volume Shadow Copy Service (VSS) requests a backup or recovery.


To select SQL databases


1. Click
 Microsoft SQL.
Machines with Agent for SQL installed are shown.

2. Browse to the data that you want to back up.
Double-click a machine to view the SQL Server instances it contains. Double-click an instance to view the databases it contains.

3. Select the data that you want to back up. You can select entire instances or individual databases.

  • If you select entire SQL Server instances, all current databases and all databases that are added to the selected instances in the future will be backed up.
  • If you select databases directly, only the selected databases will be backed up.
4. Click Backup. If prompted, provide credentials to access the SQL Server data. The account must be a member of the Backup Operators or Administrators group on the machine and a member of the sysadmin role on each of the instances that you are going to back up.
  • 6 Users Found This Useful
Was this answer helpful?

Related Articles

Starting a Backup Manually

Starting a backup manually 1. Select a machine that has, at least, one applied backup plan. 2....

Retention Rules

Retention rules 1. Click How long to keep. 2. In Cleanup, choose one of the following: By...

Recovering Files by using the Web Interface

Recovering files by using the web interface 1. Select the machine which originally contained...

Recovery Cheat Sheet

Recovery cheat sheet The following table summarises the available recovery methods. Use the...

Selecting Exchange Server Data

The following table summarizes the Microsoft Exchange Server data that you can select for backup...