Barracuda Networks 4 manual Microsoft SQL Server Backup

Page 23

Microsoft Exchange uses transaction logging to commit new and changed data to the database, and to ensure that records of the transactions exist if a store is damaged between backups. The Exchange storage group, and its associated transaction logs, is the most important data to back up on your Exchange Server to ensure your email database is available in the event it becomes damaged or unrecoverable. If you must rebuild a server, you can use the latest transaction log files plus the last full backup to recover your database.

The Barracuda Backup Agent for Microsoft Exchange Server backs up and restores the entire storage group; it allows for the storage group to be restored to a storage group or to an alternate Microsoft Exchange Server.

Microsoft SQL Server Backup

The Barracuda Backup Agent provides a complete backup of the Microsoft SQL Server including the master, user, model, msdb and pubs databases.

Barracuda Networks recommends that all of the Microsoft SQL Server user databases be configured for full recovery model so that transaction logs can be backed up. This allows you to restore a user database to any point of time that is contained within a transaction log backup.

Some versions of the Microsoft SQL Server, such as SQL Express database, do not support full recovery model. If the full recovery model cannot be used, the Barracuda Backup Agent will perform full backups of the database each time a backup runs.

The Microsoft article “Recovery Model Overview” provides more information about the Microsoft SQL Server and its three database recovery models, and how to change the recovery model of a database. The link for this article is:

http://msdn.microsoft.com/en-us/library/ms189275.aspx

Note

Do not use other methods of backing up Microsoft SQL Server databases, such as Microsoft or

third-party utilities, when using the Barracuda Backup Agent. If you use more than one method of

 

 

 

 

 

 

backing up the same database, one or more of those methods will cause the Microsoft SQL Server

 

 

 

to truncate the transaction logs. This forces a full backup of the database every time, and can result

 

 

 

 

 

 

in data that can not be restored.

Barracuda Networks recommends that you back up the master database each time it is changed. The master database contains configuration information that is required to restore an instance of SQL Server.

Windows System State Backup

The Barracuda Backup Agent can backup and restore the Microsoft Windows System State. Microsoft Windows System State backups allow backup of critical system related components, including the local Registry, COM+ Class Registration Database, the System Boot Files, Active Directory Database Files (NTDS.DIT) for Domain Controllers, and the SYSVOL folder. A System State backup can be used to recover to a known good system state after a hardware or software crash.

System State data might not include all of the information required to recover a system from a failure. Barracuda Network recommends that all boot and system volumes be backed up in addition to System State.

Configuring Backups 21

Page 22 Page 24
Image 23
Page 22 Page 24
Contents Barracuda Backup Service Copyright Notice Contents Restoring Data Securing Your BackupsAdministering the Barracuda Backup Service Site-to-Site ReplicationAppendix a About the Hardware Monitoring the Barracuda Backup ServiceAppendix B Limited Warranty and License Barracuda Backup Service Administrator’s Guide Introduction Site-to-Site Replication Features of the Barracuda Backup ServiceDeduplication for Backup Efficiency Barracuda Cloud StorageSecurity Email Message-level BackupRestore-Focused Microsoft Application SupportInterfaces Barracuda Backup Service InterfaceWeb Interface for the Barracuda Backup Server Administrative ConsoleBackup Deployment Options Deployment Options Overview Deployment Options Backup OptionsSite-to-Site Replication Site-to-Site Deployment Barracuda Backup Service Administrator’s Guide Getting Started Configuring the IP Address and Network Settings InstallationPhysically Installing the Barracuda Backup Server Configuring Your Corporate FirewallCreating an Account Linking Your Barracuda Backup Server to an AccountBarracuda Backup Service Administrator’s Guide Configuring Backups Options for Backing Up Data Overview of Backup ConfigurationWhere Data is Backed Up Microsoft SQL Server Backup Message-Level Backup Microsoft Exchange and Novell GroupWise Identify Systems to be Backed Up Steps to Backing Up DataSelecting Type of Data to Back Up Backups for Mac OS X/Linux/Unix SSH ConnectionsCreate Data Retention Policies Create Backup SchedulesModify Your Back Up Rate Limit Optional Exclude Files from a Backup OptionalCheck Backup Reports Create Rules Watch Important Backup Files OptionalBarracuda Backup Service Administrator’s Guide Before Starting Replication Configuring DestinationsSite-to-Site Replication OverviewLoss of Communication to Destination and Queue Size Specifying Data Replication DestinationDisabling a Destination Temporarily Restoring Data Restoring File Share Data Restoring from Local and Offsite BackupsRestoring Data Backed up by the Barracuda Backup Agent Restoring an Exchange Storage Group Using the Barracuda Restore Tool for WindowsRestoring Windows System State Restoring a Microsoft SQL DatabaseRestoring Exchange and GroupWise Messages Using FtpesUsing Windows Explorer and WebDAV Using FTPRestoring Data Barracuda Backup Service Administrator’s Guide Securing Your Backups Data Transmission and Storage Barracuda Backup Service SecurityCommunication and Configuration Management AccessSecuring Your Backups Oversight Barracuda Cloud Storage Standards and ProtectionStorage Facility Standards StorageBackup Security and Site-to-Site Replication Policy-Based Security Administering the Barracuda Backup Service Managing Your Account and Adding Users Administrative SettingsEdit User Settings Specific to the Barracuda Backup Service Verifying Your Barracuda Cloud Storage Service Plan SizeMonitoring the Barracuda Backup Service Viewing Back Up Statistics Monitoring Backup StatusManaging Email Notifications Backup ReportsUser Activity Reports Front Panel Indicator Lights Shutting Down a Barracuda Backup ServerWiping a Barracuda Backup Server Hardware Compliance About the HardwareBarracuda Backup Service Administrator’s Guide Exclusions and Restrictions Limited Warranty and LicenseBarracuda Networks Limited Hardware Warranty v Exclusive RemedyBarracuda 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
Top Page Image Contents