Specifications

1.
2.
3.
1.
2.
3.
4.
5.
In this Section
How to Restore a Microsoft SQL Database
How to Restore a SQL Server 2008 Master Database
How to Restore a Microsoft SQL Database to a Point-in-Time
How to Restore a Microsoft SQL Server Database to a Flat File
Related Articles
How to Change the SQL Recovery Model
How to Restore a Microsoft SQL Database
This article refers to Barracuda Backup firmware version 5.0 or higher.
In this article:
Restore a SQL User Database
Restore a SQL Master Database
Restore a SQL SharePoint Database
Restore a SQL User Database
When you request the restore of a Microsoft SQL Server user database, Barracuda Backup performs 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 Barracuda Backup restores all
intermediate required database revisions.
ToUse the following steps to restore a Microsoft SQL user database,
On the page, select the day and time from which you want to restore.RESTORE > Restore Browser
Select the data source from which you want to restore.
Select the database(s) to restore, and click .Restore
Restore a 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.
Use the following steps to recover a damaged master database,
Verify that the Barracuda Backup Agent is installed on the local machine.
Stop the SQL Server Services using the SQL Server Enterprise Manager.
Rebuild the master database; refer to for detailed procedures for your version of SQL. Microsoft Developer Network (MSDN)
Initiate Single User Restore Mode on the SQL database by entering the following from a command prompt; leave the window open after
executing the command:
CD \program files\microsoft sql server\<sql version>\mssql\binn
sqlservr -c -m (SQL 7)
sqlservr -c -m -s %<Named Instance>% (SQL 8)
After you complete the restore, remove the before you restart the server instance in the normal multi-user mode:-m
CD \program files\microsoft sql server\<sql version>\mssql\binn
sqlservr (SQL 7)
A damaged master database is evident by the failure of the SQL Server to start, by segmentation faults, or by input/output errors. The
procedure used to recover a damaged master database is different from the procedure used to recover user databases. If the master
database becomes unusable, it must be restored from a previous SQL Dump or back up. 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. It is strongly recommended that the
master database be backed up each time it is changed.