ISSUE
This guide remains to provide instructions for the use of the Legacy Unitrends SQL 2000 and 2005 Express agent. This agent is officially END OF LIFE and END OF SUPPORT. However, the agent may continue to function and this information will be retained for historical reference to the public.
The instructions below were removed from Unitrends documentation after release 10.0.0.
The detailed instructional video for this process no longer exists. Microsoft has ended all support for Microsoft SQL Server 2000, including Extended Support back in 2013 and 2005 in 2016. If your backup is successfully, please test the restore.
Customers can always use the SQL Native protection capabilities, exporting SQL backups to flat files, which the Unitrends appliance can protect with supported agent, NAS, or VM backups.
This process has not been tested with and may not work with Unitrends Secure Agent protection (SAP) released with 10.6.6 and may only function where appliances have yet to be updated to that release. Appliances cannot be downgraded. Recovery of historical backups may necessitate deployment of a temporary Unitrends virtual appliance on pre-10.6.6 release.
RESOLUTION
You will have several options to protecting Microsoft SQL 2000 Server.
- If it is on a Guest Virtual Machine, you can use the Virtual Protection to protect databases that are in SIMPLE Recovery Model. (note, no currently supported hypervisor continues to support SQL 2000 of any version or 2005 express, few support SQL below 2008, so this statement only applies for older hypervisor editions)
- If you are performing a native backup using the SQL Server Enterprise Manager, you can point the Unitrends File Level backup to collect the created files as part of its backup. To create a native SQL backup using the SQL Server Enterprise Manager, select the Management section, then right click on Backup, and select Backup a Database.
- You can use the Unitrends SQL Legacy Agent which was installed along with the Unitrends Client Agent. It becomes active when it detects MS SQL 2000 or SQL express 2005.
TASKS
YOU MUST HAVE A SUCCESSFUL CONNECTION BETWEEN THE UNITRENDS AND THE CLIENT AGENT BEFORE CONTINUING. Please add the SQL Server Client to the Unitrends Client / Protected Assets page before continuing.
- Start the MS SQL Agent option from the Unitrends Agent you installed on the SQL Server.
- In the SQL Server Functionality Shortcuts dialog box, click on the Assign a schedule strategy to a database.
- You will need to authenticate to the SQL 2000 Server. Click the Login To SQL Server to choose how and whom Unitrends should authenticate as.
- If you are choosing to authenticate using Windows Authentication, select the SQL Server Instance first, then click on the checkbox next to Use Windows Authentication, and click Login. If you are using a specific user, that user must also be the Local Administrator on the SQL Server.
- You will be presented with a Successful message or a failure. If the authentication fails correct the errors or create a user that has been given the SQL Server Role of sysadmin and dbcreator, as well as Local Administrator for the server.
- This leads you to the View / Assign Backup Profiles Wizard.
- Backup Server Name: This is your Unitrends Server hostname. If you did not add your Unitrends Server to your DNS server, you will not be able to list the server. If this is not an option, you can add it to your local hosts file (C:\windows\system32\drivers\etc).
- Backup Device Name: Select the D2DBackups. This places the backup onto the backup storage of the Unitrends Server.
- Select Database: Choose the database you wish to protect.
- Available Template Profile: Choose a profile that best matches the backup strategy for your needs.
- Click Apply. The Unitrends SQL Legacy Agent will to connect to the Unitrends backup appliance and submit the job.
- You will be presented with the results of creating the schedule if successful.