Restore a Database from a backup

This Restore Database from a backup section is intended for DoseControl Basic License users to backup and restore a MS SQL Server Express database.

It is important to back-up the database from time to time.  Scheduled backups are recommended. For large-scale users, this means setting up automated backups on servers, which will not be discussed here.  Herein is a manual method for restoring up a SQL Server Express database from a backup using Microsoft’s SQL Server Management Studio (SSMS).

IMPORTANT

You must perform the following steps using an account that has administrative privileges for the computer that is hosting SQL Server.

Step-by-Step Instructions for Restoring a SQL database from a Backup:

1        To restore a database from a *.bak file, login and navigate to the database instance in SSMS.

2        Right-click on the instance name and select “Tasks -> Restore -> Database…”.

3        The Restore Database menu opens. There will be a list and you can select an older backup if desired.  Then press the ‘OK’ button at the bottom of the screen.

4        The restore process is now complete.  SSMS will report success or errors upon restore.