How to Protect Microsoft SQL 2000 Server databses

ISSUE

The instructions are listed in the Administrators Guide – Legacy Interface beginning with page 495, but the section that is related to you is starts on page 878.

The detailed instructional video for this process no longer exists. This function is very legacy, and I must remind you that Microsoft has ended all support for Microsoft SQL Server 2000, including Extended Support back in 2013. If your backup is successfully, please test the restore.

If we stop supporting Microsoft SQL 2000 in the future, you can always use the SQL Native protection, and present to us the file and we will protect it.

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.
  • 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.

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.

  1. Start the MS SQL Agent option from the Unitrends Agent you installed on the SQL Server.
    User-added image
  2. In the SQL Server Functionality Shortcuts dialog box, click on the Assign a schedule strategy to a database.
    User-added image
  3. 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.
    User-added image
  4. 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.
    User-added image
  5. 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.
    User-added image
  6. This leads you to the View / Assign Backup Profiles Wizard.
    1. 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).
    2. Backup Device Name: Select the D2DBackups. This places the backup onto the backup storage of the Unitrends Server.
    3. Select Database: Choose the database you wish to protect.
    4. Available Template Profile: Choose a profile that best matches the backup strategy for your needs.
      User-added image
  7. Click Apply. The Unitrends SQL Legacy Agent will to connect to the Unitrends backup appliance and submit the job.
    User-added image
  8. You will be presented with the results of creating the schedule if successful.User-added image
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us