Restoring Your SQL Data

Backup for Workgroups can restore your SQL data to a new computer as part of a bare metal restore, or it can assist you with the restoration should you want to roll-back to a previous point in time.

You need to make sure that the SQL Service is NOT running at the time of the restore. 

If you are performing a bare metal restore (a restore to new equipment is a good example), you will be restoring your SQL data to a computer that is not running the SQL Service.  During the restoration process of the System Registry, the Backup Client automatically restores the appropriate SQL Server information.  You do not need to complete any additional steps.  Once the computer running SQL Server is restored, your SQL computer and the SQL data are back to normal operation.

How to Restore your SQL Data

Because SQL Server will not allow for the restoration of SQL data while the SQL Service is running, follow the steps below to stop the SQL Server first and then restore your SQL data:

1. At the computer running the SQL Server, right-click on My Computer and select Manage.

2. At the Computer Management panel, expand the Services and Applications directory tree.

3. Highlight Services.  Now the panel to the right shows you the list of currently installed Services.

4. On the Services panel, scroll the list to show the MSSQLSERVER item.

5. Right-click on the MSSQLSERVER item and select Stop.

6. Run the Backup Client software.

7. Click Restore.

8. To restore individual SQL databases, press the Selected Files button and select the appropriate files in the directory tree.  To roll-back your data to a specific point-in-time, press the Roll Back button and select the appropriate date/time entry.

9. Begin the Restore process.

10. Restart the SQL Server by repeating Steps 1-5 above but instead select Start.