Page History
The General tab of the SQL Safe Backup Policy Wizard allows you to specify the basic properties of the backup policy.
...
Depending on the needs of the backup policy. The option to select between SQL Safe file format and native SQL Server file format is available. The Format option provides two options, "SQL Safe" and "SQL Server".
| Tip |
|---|
For native SQL Server file format select "SQL Server". For SQL Safe file format, which is compatible with InstantRestore, select "SQL Safe". |
...
Choose the action that best reflects how you want to use this policy. You can create a backup policy to monitor and manage your backup jobs or just monitor them. According to your requirements, you can select from one of the following options:
| Policy Action | Description |
|---|---|
Monitor and automatically create backup jobs using the SQL Server Agent | Creates the policy for monitoring database backups and automatically creates the backup jobs using the SQL Server Agent on your SQL Server instances. Creating jobs allows to enforce consistent backup settings across your environment. |
Monitor and automatically create backup jobs using the SQL Safe Backup Agent | Creates the policy for monitoring database backups and automatically creates backup jobs using the SQL Safe Backup Agent which is in charge of executing and scheduling these policies. |
Monitor only |
...
Creates the policy to only |
...
monitor database backups and no jobs are created. |
...
By default, SQL Safe will monitor the status of any backup operation that meets the criteria of your policy. |
| Note |
|---|
Note that SQL Server Express does not support the SQL Server Agent. Use the second option if you add any instance with SQL Server Express in your policy. This option allows the SQL Safe Backup Agent (second option) to create your policy backup jobs. |
| Tip |
|---|
If you choose to use the SQL Safe Backup Agent, policy data files will be stored by default at C:\Program Files\IDERA\SQL Safe\PolicyData. You can change these settings by going to the Administration tab, selecting the General Preferences option, and typing the preferred folder directory in the Policy Data tab. |
After defining your setting in this tabOnce you define some policy settings, click Next NEXT to select your databases.