Step 1. Set Microsoft SQL Server to Single User Mode
- Log in to the SQL server as the administrator.
- Go to Administrative Tools > Services, right-click on the service SQL Server (MSSQLSERVER), and click Stop.
- Double-click SQL Server (MSSQLSERVER) to open the Service Properties dialog box.
- Click the General tab, and in the Start parameters field, type: -c -m
- Click Start in the General tab to place the server in single user mode, and then click OK to close the dialog box.
Step 2. Stop Services
- In the Services window, right-click on the service SQL Server Agent (MSSQLSERVER), and click Stop.
- In the Services window, right-click on the service SQL Server Reporting (MSSQLSERVER) service, and click Stop:
Step 3. Restore the Database
- Log in to Barracuda Backup, go to the Restore > Restore Browser page.
- Click Restore next to the Microsoft SQL Server instance to restore.
- In the Restore dialog box, select to restore to the original instance or a new instance, and click Start Restore.
Step 4. Set Microsoft SQL Server to Multi-User Mode
- Log in to the SQL server as the administrator.
- Go to Administrative Tools > Services, right-click on the following services, and click Start:
- SQL Server (MSSQLSERVER)
- SQL Server Agent (MSSQLSERVER)
- SQL Server Reporting Services (MSSQLSERVER)