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
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.
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:
At the computer running the SQL Server, right-click on My Computer
and select Manage.
At the Computer Management panel, expand the Services and
Applications directory tree.
Highlight Services. Now
the panel to the right shows you the list of currently installed Services.
On the Services panel, scroll the list to show the MSSQLSERVER
Right-click on the MSSQLSERVER item and select Stop.
Backup Client software.
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
Begin the Restore
Restart the SQL Server by repeating Steps
1-5 above but instead