Using SQL Server to Restore a Database from Backup

< Previous section  |  Table of Contents  |  Index  |  Next section >

To restore a database from a backup file, follow these steps:

  1. Start SQL Server Management Studio and connect to the SQL Server instance that manages the MainBoss database.
  2. In the left-hand panel, expand Databases.
  3. Right-click on the entry for the database you want to restore, then click Tasks, then click Restore, then click Database.
  4. SQL Server opens a window displaying your existing backup files. In the list of available backups, click the one you want to restore.
  5. Click OK.

The restoration process will overwrite any existing contents of the database. Therefore, you should only restore a database if the current contents are no longer usable.

< Previous section  |  Table of Contents  |  Index  |  Next section >