Page History
Use the Membership tab of the SQL Safe Backup Policy wizard Wizard to select which SQL Server instances and databases you want to monitor with this policy.
Follow these steps to select your instances and databases:
- Click Add/Remove remove Instances and choose the instances from where you want to backup databases. Click OK.
For each selected SQL Server instance, define which databases SQL Safe will take into account for this policy. You can select from the following options: All Databases, All User Databases, All System Databases, Specific Databases.
ByWhen choosing one of the
"All"database options, the policy will automatically include the relevant databases as they are added on the server and the Edit Database Selection window opens.
When selecting databases, you can- In the Edit Database Selection window some options are available depending on the databases you chose in the previous step. You can use the WildCard option or the Manually option to exclude or include specific databases from your backup.
Tip When you use the WildCard options:
- % or * - substitutes one or more
characters - characters
- _ - substitutes a single character
- \\ - type double backlash to avoid it acting as the escape character
- [abc] - searches for abc
- [^abc]- searches and matches for those characters that are not abc
- [ a-c] - searches and matches a, b, or c
- SQL Safe opens a new window and allows you to view which databases you are selecting for your policy. Click OK.
Tip |
---|
When choosing the databases you need to backup, you can also specify the ones you want to exclude from your policy. To exclude databases, move them to the list on the left. |
After defining your setting in this tab, click Next to Configure Once you select your databases, click NEXT to configure your backup options.
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...