Versions Compared

Version Old Version 1 New Version Current
Changes made by

Krzysztof Kot

Manuel Gutierrez (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

This article provides a very simple outline for restoring a database backup and assigning user rights using SQL Server Management Studio. There are different ways of restoring a database on a SQL instance, and considerations should be given to the location and sizing of data files and log files as well as disaster recovery and general SQL Server serrings. The below is not exhaustive documentation and is presented only for users unfamiliar with the restore process. 

Contents

Table of Contents
excludeContents

Overview

This article should only be used by those administrators unfamiliar with how to restore a database on a SQL Server instance. For recommendations around the configuration of SQL Server for a QEST Platform database, please see the SQL Server Configuration Recommendations article.

Prerequisites

In order to complete these steps, the following will be required:

  • An instance of MSSQL version 2008R2 or greater

  • The database backup file

    • The QEST Platform database backup will likely be named QESTLab_MMDDYYY.bak

    • The Hive Publishing database backup will likely be named HivePublish_MMDDYYYY.bak

Restoring a Database on Microsoft SQL Server

  1. Open up SQL Server, enter the Server (SQL instance) name and Authentication information. Then Connect.

  2. Create a new Database with the following information:

    1. Database Name:

      1. QESTLab for QEST Platform databases

      2. Hive_Publish for Hive publishing databases

...