Barracuda Networks 4 manual Microsoft SQL Server Backup, Windows System State Backup

Models: 4

1 69
Download 69 pages 27.65 Kb
Page 23
Image 23
Microsoft SQL Server Backup

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 23
Image 23
Barracuda Networks 4 manual Microsoft SQL Server Backup, Windows System State Backup, in data that can not be restored