Restoring the MS SQL Server database

Edit online

If you encounter any problems with your database or if you want to move it between different instances of License Metric Tool, you can use a backup file to restore the database.

Before you begin

  • You can back up and restore the database only within one version of License Metric Tool.
  • Ensure that you are logged in to Microsoft SQL Server Management Studio as the user who created the temadb database. If you log in as a different user, the restoring will fail.
  • License Metric Tool and Microsoft SQL Server Management Studio must be installed.
  • Stop the LMTserver service. Open the command prompt and run net stop LMTserver.

Procedure

  1. Log in to the computer on which you want to restore the database.
  2. Open Microsoft SQL Server Management Studio.
  3. In the left navigation bar, right-click on Databases and then click Restore Database.
    Restoring the database.
  4. In the Source section, select Device and click the button with three dots.
    Browsing for the device.
  5. In the pop up window that opens, click Add and browse for your backup file. Click OK.
  6. In the left navigation menu, click Options.
  7. In the pane on the right select Overwrite the existing database (WITH REPLACE) and Close existing connections to destination database.
  8. Click OK.