Skip to main content

Restore to an Existing TIER Database

  1. Last updated
  2. Save as PDF

Overview

This document describes how to restore to an existing TIER database.

Steps

If the database you are restoring to has not been registered in TIER before, after restoring the database, you must register it in TIER and repair the logins. See Register a TIER Database for the procedure.

  1. Open either SQL Enterprise Manager (SQL2000) or SQL Server Management Studio (SQL2005).

tier-db14.png

  1. In the Treeview, expand Databases by clicking the plus sign (+), then select the database you want to restore to.
    Important: Please remember that a restore COMPLETELY overwrites the existing database and all data will be replaced with the data from the BAK file being restored.

tier-db15.png

  1. Right-click the database you want to restore, then select Tasks > Restore > Database.

tier-db16.png

  1. The Restore Database window will open. Under Select a page, click General.
  2. On the General page go to the Source for restore section and select From device. 

tier-db17.png

  1. Next to the From device field, click the ellipsis button ellipsis-button.png to open the Specify Backup window, then click Add.

tier-db18a.png

  1. The Locate Backup File window will open.

tier-db19a.png

  1. Navigate to the location on your computer where the backup file to be restored is located. Select the file and click OK.

tier-db20.png

  1. The Specify Backup window will reappear with the backup file location listed. Confirm the location and click OK.

tier-db21.png

  1. The Restore Database window will reappear. In the Select the backup sets to restore section, click the Restore check box next to the backup set.

tier-db22.png

  1. Under Select a page, click Options.
  2. On the Options page go to the Restore options section and click the Overwrite the existing database check box.

tier-db23.png

  1. Important: In the Restore the database files as section you you can ignore the Original File Name, but you must correctly select the location and name of the Restore As database, which is the database that you are restoring to. The system will default to the location and file name that the backup file was created from, and this may not be the same as where you are restoring to. There are two files that make up one database: the Data file and the Log file; you will need to specify both. For example, if you wanted to restore wfs_demo to a new database named wfs_demo2 you would need to specify the Data file and the Log file.
    To select the Data file, in the Restore the database files as section, click the ellipsis button ellipsis-button.png in the first row.

tier-db24.png

  1. The Locate Database Files window will open. Navigate to the location of the data file for the database you are restoring. On a laptop this is usually c:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\data\<Database name>.mdf.

tier-db25.png

  1. Click OK and the Restore Database window will reappear. In the Restore the database files as section, click the ellipsis button ellipsis-button.png in the second row to select the Log file.

tier-db26.png

  1. The Locate Database Files window will open again. Navigate to the location of the Log file for the database you are restoring. On a laptop this is usually c:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\data\<Database name_log>.ldf.

tier-db27.png

  1. Click OK and the Restore Database window will reappear. Click OK and the restore will begin. You can monitor the progress in the Progress area in the lower left corner of the window.

tier-db28.png

  1. When the restore is complete, the Completion window will appear. Click OK to close the window.

tier-db29.png