Library Table of Contents Index Previous Page (Alt-p) Next Page (Alt-n) Comments

Using the Number of Databases that Can Be Backed Up Concurrently screen

Use the Number of Databases that Can be Backed Up Concurrently screen to view and change the maximum number of databases that can be backed up concurrently. For more information, go to any of the following topics:

Related topics

Implications of the maximum number of databases that can be backed up concurrently  Top

By default, SnapManager backs up all databases on the same storage system volume concurrently. To limit the system resource used by SQL Server during SnapManager Snapshot copy backup, you can limit the number of databases that can be backed up concurrently.

Note
Limiting the number of databases can be backed up concurrently may increase the number of Snapshot copies that are required to backup all of the databases. In the case of multiple databases sharing one or two LUNs, if the number of databases allowed to be backed up concurrently is less than the actual number of databases that share the LUNs, then the backup will be split. In this case, a copy-based restore method will be used to restore from this backup set.

Changing the maximum number of databases that can be backed up concurrently  Top

To change the maximum number of databases that can be backed up concurrently, complete the following steps from within the Number of Databases that Can Be Backed Up Concurrently screen of the Configuration Wizard.

Note
The maximum number of databases allowed per backup can also be configured using the Backup Setting dialog box. See Configuring the profile of a full database backup.

Step

Action

1

To change the maximum number of databases that can be backed up concurrently, type a new value in the text box labeled Maximum Databases to be Snapshot Backed up in Parallel.

The default value is 255.

2

If you want to modify the maximum number of SQL Server worker threads, select the Modify SQL Server "Maximum worker threads" parameter option. This option is deselected by default.

Library Table of Contents Index Previous Page (Alt-p) Next Page (Alt-n) Comments