Skip to main content

Restore your Lyris LM SQL Server Database

Teague James
  • Updated

Overview

You have been maintaining regular backups of your ListManager Microsoft SQL Server Database by following the steps in the Backup Your Lyris LM SQL Server Database article. Now you need to restore your database from one of those backups and you would like to know how.

Prerequisites

  • Administrator access to your Lyris LM SQL Server

Solution

NOTE: Changes that were made to your system from the date of the backup you are restoring to the present will be lost after you complete the restoration process.
  1. Stop your Lyris LM system, including ListManager, ListManagerWeb, and any Nodes

  2. Log on to your Microsoft SQL Server as an Administrator

  3. Using File Explorer, navigate to your SQL Server Data directory, C:\Program Files\Microsoft SQL Server\MSSQL\Data\

  4. Rename ListManager_Data.MDF to ListManager_Data_BAK.OLD and confirm when prompted

  5. Rename ListManager_Log.LDF to ListManager_Log_BAK.OLD and confirm when prompted

  6. Copy the ListManager_Data.MDF and ListManager_Log.LDF from your backup location to this folder

  7. Start your Lyris LM system, including ListManager, ListManagerWeb, and any Nodes

Your database is restored from the backup and operates without errors.

Related Articles

Related articles