In the SQL Safe Agents navigation pane, click on Upgrade Agents, the following options are available in the wizard:
How do you set the account for the SQL Safe Backup Agent upgrade?
In the Authentication tab, specify a Windows Account for the SQL Safe Agent Upgrade. You have two options:
- Currently logged in on Windows Account: by default, SQL Safe uses the specified Windows Account to access and install the SQL Safe Agent on the targeted server.
- Use another account.
How do you set the SQL Safe Backup Agent for the upgrade?
In the Agents tab, you can see a navigation screen table with the list of SQL Safe Backup Agents registered for the upgrade.
| Column | Definition |
|---|---|
| Computer | Displays the SQL Safe Backup Agent name. |
| Current Version | Displays the current version of the SQL Safe Backup Agent. |
| Management Server | Displays the previous management server set in the Authentication screen. |
Click Add/Remove Agents to set the list of Agents you want to upgrade to the current version of the SQL Safe Management Console. A popup window appears with the following options:
- 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.
What agent configuration can you change?
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.
How do you configure notifications for the SQL Safe Agent Upgrade?
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.
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.
Review the summary before your upgrade
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. |