Barracuda Networks 4 manual Restoring a Microsoft SQL Database, Restoring Windows System State

Page 36

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.

34 Barracuda Backup Service Administrator’s Guide

Image 36
Contents Barracuda Backup Service Copyright Notice Contents Securing Your Backups Administering the Barracuda Backup ServiceSite-to-Site Replication Restoring DataMonitoring the Barracuda Backup Service Appendix B Limited Warranty and LicenseAppendix a About the Hardware Barracuda Backup Service Administrator’s Guide Introduction Features of the Barracuda Backup Service Deduplication for Backup EfficiencyBarracuda Cloud Storage Site-to-Site ReplicationEmail Message-level Backup Restore-FocusedMicrosoft Application Support SecurityBarracuda Backup Service Interface Web Interface for the Barracuda Backup ServerAdministrative Console InterfacesBackup Deployment Options Deployment Options Overview Backup Options Deployment OptionsSite-to-Site Replication Site-to-Site Deployment Barracuda Backup Service Administrator’s Guide Getting Started Installation Physically Installing the Barracuda Backup ServerConfiguring Your Corporate Firewall Configuring the IP Address and Network SettingsLinking Your Barracuda Backup Server to an Account Creating an AccountBarracuda Backup Service Administrator’s Guide Configuring Backups Overview of Backup Configuration Where Data is Backed UpOptions for Backing Up Data Microsoft SQL Server Backup Message-Level Backup Microsoft Exchange and Novell GroupWise Steps to Backing Up Data Identify Systems to be Backed UpBackups for Mac OS X/Linux/Unix SSH Connections Selecting Type of Data to Back UpCreate Backup Schedules Create Data Retention PoliciesExclude Files from a Backup Optional Modify Your Back Up Rate Limit OptionalCreate Rules Watch Important Backup Files Optional Check Backup ReportsBarracuda Backup Service Administrator’s Guide Configuring Destinations Site-to-Site ReplicationOverview Before Starting ReplicationSpecifying Data Replication Destination Disabling a Destination TemporarilyLoss of Communication to Destination and Queue Size Restoring Data Restoring from Local and Offsite Backups Restoring Data Backed up by the Barracuda Backup AgentRestoring File Share Data Using the Barracuda Restore Tool for Windows Restoring an Exchange Storage GroupRestoring a Microsoft SQL Database Restoring Windows System StateUsing Ftpes Restoring Exchange and GroupWise MessagesUsing FTP Using Windows Explorer and WebDAVRestoring Data Barracuda Backup Service Administrator’s Guide Securing Your Backups Barracuda Backup Service Security Communication and ConfigurationManagement Access Data Transmission and StorageSecuring Your Backups Barracuda Cloud Storage Standards and Protection Storage Facility StandardsStorage OversightBackup Security and Site-to-Site Replication Policy-Based Security Administering the Barracuda Backup Service Administrative Settings Edit User Settings Specific to the Barracuda Backup ServiceVerifying Your Barracuda Cloud Storage Service Plan Size Managing Your Account and Adding UsersMonitoring the Barracuda Backup Service Monitoring Backup Status Viewing Back Up StatisticsBackup Reports User Activity ReportsManaging Email Notifications Shutting Down a Barracuda Backup Server Wiping a Barracuda Backup ServerFront Panel Indicator Lights About the Hardware Hardware ComplianceBarracuda Backup Service Administrator’s Guide Limited Warranty and License Barracuda Networks Limited Hardware Warranty vExclusive Remedy Exclusions and RestrictionsBarracuda Networks Software License Agreement v Limited Warranty and License Barracuda Backup Service Administrator’s Guide Limited Warranty and License Barracuda Networks Software License Agreement Appendix Preamble Barracuda Backup Service Administrator’s Guide Limited Warranty and License Barracuda Backup Service Administrator’s Guide Limited Warranty and License Barracuda Backup Service Administrator’s Guide Limited Warranty and License END of Terms and Conditions Index