Warning: MS SQL Server 2000 is no longer supported by MetaCommunications products. This information is retained for customers using older versions.

1. Open Microsoft SQL Server 2000 Enterprise Manager, log in, and navigate to the database you want to restore.
   
2. Right click the database you want to restore. A context menu will appear.

   Note: If you want to restore your backup file(s) to a new database, right click any database in the list. You will have the opportunity to select an existing database or create a new database further on in the procedure.

   

3. Select All Tasks, then Restore Database... in the context menu (see above). The Restore Database window will open.
   
4. Check the name in the “Restore as database” field. You can select an existing database to which you want to restore, or you can type the name of a new database in this field. Restoring to an existing database will replace any information in the current database with the information from the database backup files.
5. Select the “Database” radio button in the Restore group if it is not already selected.
6. Select the full backup file you want to restore from in the “First backup to restore” field. The backup file will appear in the restore list, along with any incremental backup files made after the full backup.
7. Enable the restore checkboxes for the full backup file and any transaction log backups you want to restore from.
   
8. If you are attempting to restore to an existing database: Select the Options tab and enable the “Force restore over existing database” checkbox. If you are attempting to restore to an new database, continue with the step below.
9. If you are attempting to restore to an existing database: Select the Options tab and type the path to the .mdf and .ldf files you want to overwrite with the restored database. By default, the path information will point to the original .mdf and .ldf files for which the backup was created and must be changed.
10. Click OK. A progress indicator window will open, illustrating the progress of the database restoration.
    
    When the database restoration is complete, the Complete window will appear.
    
11. Click OK in the Complete window. The window will close and return you to the MS SQL Server 2000 Enterprise Manager.

If you have restored to an existing database, test the functionality of your Workgroups application(s) to ensure that everything is functioning as expected. If you have restored to a new database, you will need to create a database link in the Application Server and attach the database to any relevant MetaData Console snap-ins before you will be able to log in and test the database functionality with your Workgroups applications. See the Application Server User Guide and the MetaConsole Guide for more information.