QEST Platform 4.90
Applies to All

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

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

Open up SQL Server, enter the Server (SQL instance) name and Authentication information. Then Connect.
Create a new Database with the following information:
1. Database Name:
  1. QESTLab for QEST Platform databases
  2. Hive_Publish for Hive publishing databases
    Different Environments
    
    When restoring databases for development or testing environments it is good practice to add a suffix to the database name to identify the environment (e.g. QESTLab_Test)
2. For initial size and autogrowth settings please refer to SQL Server Configuration Recommendations
3. For recommended settings around filegroups please refer to SQL Server Configuration Recommendations
Click OK.
Right click on the newly created database and go to Database -> Task -> Restore -> Database…
On the Restore Database window under Source click the Device option and then the … to search for the backup file.
On the Select backup devices child window, click on Add and search for the backup file
On the Locate Backup File child window select the backup file and click OK. The backup file will be shown on the Restore Plan.
On the Restore Database window go to Options and check box Overwrite the existing database (WITH REPLACE) option and click OK.
After the database has been restored, users will need to be granted the necessary access, please refer to Granting Access to the QEST Platform Database for more details on this step

Products described on these pages, including but not limited to QESTLab®, QESTNet, QESTField, Construction Hive, and associated products are Trademarks (™) of Spectra QEST Australia Pty Ltd and/or related companies.

The content of this page is confidential. Do not share, duplicate or distribute without permission.

© 2020 Spectra QEST® Australia Pty Ltd and/or related companies. Terms of Use and Privacy Statement

Browser not supported