|
The first step is to restore the database from the Storage
Platform.
Click on the Restore tab
and select the dump folder from the specific backup
date.
From the File menu, click on
Restore . Select a restore location
and restore the database.
The next step is to restore the database from the recovered file.
Open the SQL Enterprise
Manager . From the Console root, expand Microsoft
SQL Servers and browse to the Server where you would
like to restore the database.
Expand the databases section
and select the database. If the database does not exist
anymore, you have to create and configure the database
first.
Right-click on the database, select All
Tasks and click Restore Database .
In the Restore as database window,
select the database you want to restore.
Select From
device and then click on Select Devices
.
From the Restore from option,
select disk and then click on Add
. Browse to the folder where you have restored
the database and select the file.
Click on OK
accept the filename selected and OK
again to accept the device.
Using SQL functionality,
you can select how you would like to restore the backup
set. You can choose between a complete or differential
database, the transaction log or file group.
If you
are restoring to a new database you have to enable SQL
to overwrite the database.Open the Options tab and click
in the checkbox next to Force restore over existing
database .
Click on OK to
start the database restore. DO NOT INTERRUPT THIS PROCESS ONCE YOU HAVE STARTED THE SQL RESTORE
SQL Server Enterprise Manager
will confirm that you have successfully restored the
selected database. |
