Page History
...
- 9.1 Upgrade the SQL Safe Backup Agent
Notifications
Anchor Authentication Authentication
How do you set the account for the SQL Safe Backup Agent upgrade?
| Authentication | |
| Authentication |
...
- Search Bar - allows you to search for Agents to upgrade.
Exclude/Include SQL Safe Agents - allows you to set the desired operation for the upgrade. For each option, you see:
Column Definition Computer Displays the SQL Safe Backup Agent name. Current Version Displays the current version of the SQL Safe Backup Agent.
Anchor Configuration Configuration
What agent configuration can you change?
| Configuration | |
| Configuration |
On the Configuration tab, you can specify the Management Server and Service Accounts for the upgraded agents. Click on Next and a popup window appears asking if you would like to configure all SQL Safe Agents listed to use the same Management Server or Service Account. If Yes, SQL Safe applies the change to all agents in the list. If No, SQL Safe applies the change to only the selected agent.
| Anchor | ||||
|---|---|---|---|---|
|
On the Notifications tab, you can email status notifications to the appropriate database administrators about this SQL Safe Agent Upgrade. Email notifications let you, and your staff, remotely monitor the status of your backups.
You can choose any of the following events to monitor:
- Agent upgrade fails.
- Agent upgrade is cancelled by user.
- Agent upgrade succeeds.
Type the email address of each recipient. Use semicolons to separate multiple email addresses.
| Tip |
|---|
You must configure your mail server settings before SQL Safe can send email notifications. Click Configure E-mail to check your settings. For more information, see configure e-mail settings for status notifications. |
SQL Safe sends an email to the specified recipients only when the selected event occurs. For example,
every time a selected event occurs
only on the initial occurrence of a selected event
if you chose to monitor whether the backup fails, you will not be emailed if the backup is skipped. Because you are performing a manual backup, you will receive one status notification.
| Anchor | ||||
|---|---|---|---|---|
|
The Summary tab provides a summary of specified values and options you have selected in the SQL Safe Agent Upgrade wizard.
After you review the information, click Upgrade to perform immediately the upgrade to the Agent, or click Generate Script to create a script you can use to upgrade the Agent at a later time. For more information about generating scripts, see how script generation works.
If you chose to upgrade the Agent immediately, and want to verify its status go to the SQL Safe Agents tab and review the Upgrade Status section. For more information, see view Backup/Restore operation status.
What actions can you perform on the Summary tab?
| Action | Steps |
|---|---|
| Immediately backup databases | Click Backup, and then highlight the instance or database in the tree pane to see the status of the operation. |
| Create a CLI backup script | Click Generate Script, and then click Command Line. To Save the script to a file, click the saving icon or the Copy script to clipboard icon respectively. SQL Safe creates a backup script using the settings you specified for the selected databases. You can use this script to perform future backups of any system or user database you selected. Click Close to return to the Backup Wizard. |
| Create a T-SQL backup script | Click Generate Script, and then click T-SQL. To Save the script to a file, click the saving icon or the Copy script to clipboard icon respectively. SQL Safe creates a backup script using the settings you specified. You can use this script to perform future backups of any system or user database you selected. Click Close to return to the Backup Wizard. This script requires the SQL Safe XSP. For more information on installing the SQL Safe XSP, see deploy the SQL Safe XSP. For more information about how to use the SQL Safe XSP, see the sample scripts available from the Programs menu. |