Specifications

5.
6.
7.
8.
9.
1.
2.
3.
1.
2.
3.
4.
sqlservr -s %<Named Instance>% (SQL 8)
If login IDs or devices have been added to or dropped from the master database since the last backup, those changes must be reapplied.
Restart the server and reapply the changes manually or from saved batch files.
If any databases have been created, expanded, or shrunk since the last dump of the master, those databases must be dropped and then
restored. Refer to for detailed procedures for your version of SQL.http://msdn.microsoft.com
Close the command prompt.
Restart the SQL Service using SQL Enterprise Manager.
Restore a SQL SharePoint Database
Use the following steps to restore a SQL SharePoint database:
Start the Windows SharePoint Services VSS Writer service.
Start the Volume Shadow Copy service.
Shut down any web applications whose content is being restored.
How to Restore a SQL Server 2008 Master Database
This article refers to all Barracuda Backup firmware versions, and Microsoft SQL Server 2005 and 2008.
®
In this article:
Set Microsoft SQL Server to Single User Mode
Stop Services
Restore the Database
Set Microsoft SQL Server to Multi-User Mode
Set Microsoft SQL Server to Single User Mode
Log in to the SQL server as the administrator.
Go to , right-click on the service , and click .Administrative Tools > Services SQL Server (MSSQLSERVER) Stop
Double-click to open the dialog box.SQL Server (MSSQLSERVER) Service Properties
Click the tab, and in the field, type: General Start parameters -c -m