beautypg.com

Restoring a microsoft sql database, Restoring an sql user database, Restoring an sql master database – Barracuda Networks 4 User Manual

Page 36: Restoring windows system state

background image

34 Barracuda Backup Service Administrator’s Guide

Refer to the Barraucuda Networks Knowledgebase Solution “How to use the Recovery Storage group
feature for Microsoft Exchange with the Barracuda Backup Service?” at

http://www.barracudanetworks.com/kb?id=50160000000ICSf

for detailed instructions.

Restoring a Microsoft SQL Database

Restoring an SQL User Database

When you request the restore of a Microsoft SQL user database, the Barracuda Backup Service will
perform all of the restores required to get to the desired date, as follows:

Restore a full backup of the SQL Server database.

Restore the incremental backups in the order in which they were created.

In other words, if you want to restore the database to a certain date, simply select the date and that
database and the Barracuda Backup Service will restore all intermediate required database revisions.

To restore a Microsoft SQL User Database:

1.

On the

RESTORE> Restore Brower

page

,

select the day and time from which you want to

restore.

2.

Select the data source from which you want to restore.

3.

Select the database(s) to restore and click

Restore

.

Restoring an SQL Master Database

If the master database becomes unusable, it must be restored from a previous SQL Dump or backup.
All changes made to the master database after the last backup or dump are lost when the dump is
reloaded and therefore must be reapplied.

Refer to the Barraucuda Networks Knowledgebase Solution “How do I restore a SQL database with
the Barracuda Backup Service?” at

http://www.barracuda.com/kb?id=50160000000IEEI

for instructions for restoring a SQL master

database.

Restoring Windows System State

Restoring Windows System State should only be performed in a disaster recovery situation.
Typically, this is if a server goes down and is not recoverable or if the configuration is severely
corrupted.

For instructions for restoring System State for a Microsoft Windows 2008 server, refer to the
Barraucuda Networks Knowledgebase Solution “How can I perform a System State Restore from my
Barracuda Backup Service on a Windows 2008 server?” at

http://www.barracuda.com/kb?id=50160000000IV6G

These instructions also describe how to restore System State on a Windows 2008 Active Directory
domain controller.