Ask the Community
Groups
How to Protect Microsoft SQL 2000 Server databses - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p><span style="color: #010101;">The instructions are listed in the</span> <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Funitrends-support.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360013273878"><span style="color: #0563C1;"><u>Administrators Guide – Legacy Interface</u></span></a> <span style="color: #010101;">beginning with page 495, but the section that is related to you is starts on page 878.</span><br><br><span style="color: #010101;">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</span> <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Flifecycle%2Fsearch%3Falpha%3DSQL%25202000"><span style="color: #0563C1;"><u>Microsoft SQL Server 2000</u></span></a><span style="color: #010101;">, including Extended Support back in 2013. If your backup is successfully, please test the restore.<br><br>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.</span></p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p><span style="color: #010101;">You will have several options to protecting Microsoft SQL 2000 Server.</span> </p> <ul><li><span style="color: #010101;">If it is on a Guest Virtual Machine, you can use the Virtual Protection to protect databases that are in</span> <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Fsql%2Flegacy%2Faa224769%28v%3Dsql.80%29"><span style="color: #0563C1;"><u>SIMPLE Recovery Model</u></span></a><span style="color: #010101;">.</span></li> <li><span style="color: #010101;">If you are performing a native backup using the <b>SQL Server Enterprise Manager</b>, 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.</span></li> <li><span style="color: #010101;">You can use the <b>Unitrends SQL Legacy Agent</b> which was installed along with the Unitrends Client Agent. It becomes active when it detects MS SQL 2000.</span></li> </ul><h2 data-id="tasks"><strong>TASKS</strong></h2> <p><span style="color: #010101;"><b>YOU MUST HAVE A SUCCESSFUL CONNECTION BETWEEN THE UNITRENDS AND THE CLIENT AGENT BEFORE CONTINUING.</b> Please add the SQL Server Client to the Unitrends Client / Protected Assets page before continuing.</span> </p> <ol><li><span style="color: #010101;">Start the <b>MS SQL Agent</b> option from the <i>Unitrends Agent</i> you installed on the SQL Server.</span><br><img alt="User-added image" src="https://us.v-cdn.net/6032361/uploads/migrated/DLB94C8NZRKI/eid-ka83r000000k9rf-feoid-00n40000003czok-refid-0em40000000ac99." class="embedImage-img importedEmbed-img"></img></li> <li><span style="color: #010101;">In the SQL Server Functionality Shortcuts dialog box, click on the <b>Assign a schedule strategy to a database</b>.</span><br><img alt="User-added image" src="https://us.v-cdn.net/6032361/uploads/migrated/HH0Y8PCECLM5/eid-ka83r000000k9rf-feoid-00n40000003czok-refid-0em40000000ac9e." class="embedImage-img importedEmbed-img"></img></li> <li><span style="color: #010101;">You will need to authenticate to the SQL 2000 Server. Click the <b>Login To SQL Server</b> to choose how and whom Unitrends should authenticate as.</span><br><img alt="User-added image" src="https://us.v-cdn.net/6032361/uploads/migrated/13T932Y1UR6F/eid-ka83r000000k9rf-feoid-00n40000003czok-refid-0em40000000ac9j." class="embedImage-img importedEmbed-img"></img></li> <li><span style="color: #010101;">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.</span><br><img alt="User-added image" src="https://us.v-cdn.net/6032361/uploads/migrated/585V72RA4H1I/eid-ka83r000000k9rf-feoid-00n40000003czok-refid-0em40000000ac9o." class="embedImage-img importedEmbed-img"></img></li> <li><span style="color: #010101;">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 <b>SQL Server Role</b> of <b>sysadmin</b> and d<b>bcreator</b>, as well as Local Administrator for the server.</span><br><img alt="User-added image" src="https://us.v-cdn.net/6032361/uploads/migrated/XKQOSMOXU2VD/eid-ka83r000000k9rf-feoid-00n40000003czok-refid-0em40000000ac9t." class="embedImage-img importedEmbed-img"></img></li> <li> <span style="color: #010101;">This leads you to the <b>View / Assign Backup Profiles Wizard</b>.</span> <ol><li><span style="color: #010101;"><b>Backup Server Name</b>: 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).</span></li> <li><span style="color: #010101;"><b>Backup Device Name</b>: Select the <b>D2DBackups</b>. This places the backup onto the backup storage of the Unitrends Server.</span></li> <li><span style="color: #010101;"><b>Select Database</b>: Choose the database you wish to protect.</span></li> <li><span style="color: #010101;"><b>Available Template Profile</b>: Choose a profile that best matches the backup strategy for your needs.</span><br><img alt="User-added image" height="310" src="https://us.v-cdn.net/6032361/uploads/migrated/P703VR3XYQIN/eid-ka83r000000k9rf-feoid-00n40000003czok-refid-0em40000000ac9i." width="500" class="embedImage-img importedEmbed-img"></img></li> </ol></li> <li><span style="color: #010101;">Click <b>Apply</b>. The Unitrends SQL Legacy Agent will to connect to the Unitrends backup appliance and submit the job.</span><br><img alt="User-added image" src="https://us.v-cdn.net/6032361/uploads/migrated/BUNDD2Q6JIBC/eid-ka83r000000k9rf-feoid-00n40000003czok-refid-0em40000000ac9y." class="embedImage-img importedEmbed-img"></img></li> <li><span style="color: #010101;">You will be presented with the results of creating the schedule if successful.<img alt="User-added image" src="https://us.v-cdn.net/6032361/uploads/migrated/QPL8QP6U2JPL/eid-ka83r000000k9rf-feoid-00n40000003czok-refid-0em40000000ac9d." class="embedImage-img importedEmbed-img"></img></span></li> </ol> </article> </main>