Restore Shavlik Database From Backup Using SQL Server Management Studio

Version 7

    Purpose

     

    This document outlines how to restore a Shavlik Database to an SQL Instance.

     

    Resolution

     

    Shavlik Protect and Ivanti Patch for Windows Servers does not have a built in Restore from Backup utility. Use the following instructions to use SQL Server Management Studio to restore from backup:

         1. If you have not yet installed it, download and install SQL Server Management Studio. You can download and install the latest version from here.

         2. Connect to the appropriate SQL Server Instance and login with the appropriate credentials. This is either [hostname] for full SQL instances or  [hostname]\SQLEXPRESS for SQL Express instances. Default authentication will be Windows Authentication.

         3. Right-click Databases, then select Restore Database.

     

         4. Change Source from Database to Device. Using the button, click Add to then navigate to the backup file for your database. This file should preferably be a .bak file.

         5. Once backup file is selected and added, SQL will check the database file to make sure its valid. As long as no errors are received, click OK to begin the restore.

         6. Once restore is successful, the database will show under Database.

    Additional information

    How To: Backup a Database

    How to Create a New Protect Database or Change Existing Database Link

    Restore a Database Backup Using SSMS | Microsoft Docs

     

    Affected Product(s)

     

    Shavlik Protect 9.2

    Ivanti Patch for Windows Servers 9.3