P a g e | 2 Document version 1.7.15
Table of Contents
INTRODUCTION 3
TYPES OF RESTORE 3
STEPS INVOLVED IN THE RESTORE 3
IDENTIFY THE DATABASE 3
LOGIN TO SQLSERVER MANAGEMENT STUDIO 4
SELECT THE DATABASE PROPERTIES 4
DATABASE FILE PROPERTIES 5
SELECT THE DATABASE 6
SELECT THE RESTORE OPTION 7
SELECT TO RESTORE THE PHYSICAL FILE 8
SELECT THE BACKUP SET 10
OPTIONS 11
Introduction
Types of Restore
The SQL Server supports 2 type of restore, namely;
a) Normal Restore; You can use the normal restore if you want to have the current database restored back into the same database (so a backup of the Database you will be overwriting must to be done first)
b) Redirected Restore; .A redirected restore will restore the data from the point at which the last backup was done to a specified Workarea.
Steps involved in the Restore
Identify the database
P a g e | 4 Document version 1.7.15
Login to SQL Server Management Studio
Once the database is identified, we then need to open the sql server management studio and either login as a windows user or as an SQL server user (normally PCSchool sql server user is a powerful user and you can complete the login as that user).
Database file properties
P a g e | 6 Document version 1.7.15
Select the database
Select the Restore Option
There are 2 different restore options possible.
a) Normal restore; We will select “From device” on the assumption that we need to restore this backup into the database it was taken from, thus overwriting the data in there.
P a g e | 8 Document version 1.7.15
Select to Restore the physical file
P a g e | 10 Document version 1.7.15
Select the Backup set
Options
Before we do the restore, we need to make changes in the options tab, after selecting the backup set. This options tab will have information read from the backup set. What Microsoft does is, whenever a backup is taken, it will store information on “What the database name is”, “What the physical location was” and “What the physical file name is”. If we have the backup of a database (lets say PCSchool database) and if we are trying to restore the current PCSchool database with this backup, everything should be okay. But when you have a backup of PCSchool and you are trying to restore it on some other work area. A common situation is, trying to restore to PCSPlay, we need to make sure that the path is correct. As we have taken the file name and its path in our initial step, it’s just a matter of pointing it to correct path and physical file.
P a g e | 12 Document version 1.7.15