Warning: MS SQL Server 2000 is no longer supported by MetaCommunications products. This information is retained for customers using older versions.
Two methods for restoring backups in MS SQL Server 2000 are described in this section. While the process for restoring from each type of backup are similar, there are some significant differences that need to be considered when you attempt to restore a database. Please review the following explanations before deciding on the appropriate database restoration procedure:
Restoring from scheduled maintenance plan backups - Databases that are backed up according to a recommended maintenance plan include daily full database backup files and incremental (transaction log) backup files created every two hours. Restoring from maintenance plan backups will give you the ability to include the transaction log files in your restoration. See [“Restoring from scheduled maintenance plan backups” on page 143] for step-by-step instructions.
Restoring from on-demand backups - On-demand backups are full database backups that you create during the course of upgrading the MetaCommunications Server, or for any number of other reasons where it makes sense to create a full database backup instead of relying on the database backups created by your maintenance plan. One common situation where you would use this method is for restoring a database from a backup file recovered from tape or one that has been copied from another machine. The procedure for restoring from on-demand backups describes restoring from a full database backup without transaction logs. See [“Restoring from on-demand full database backups” on page 147] for step-by-step instructions.
Procedures
Restoring From Scheduled MS SQL Server 2000 Maintenance Plan Backups
Warning: MS SQL Server 2000 is no longer supported by MetaCommunications products. This information is retained for customers using older versions.
Open Microsoft SQL Server 2000 Enterprise Manager, log in, and navigateto the database you want to restore.
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.
Select All Tasks, then Restore Database... in the context menu (see above). The Restore Database window will open.
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.
Select the “Database” radio button in the Restore group if it is not already selected.
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.
Enable the restore checkboxes for the full backup file and any transaction log backups you want to restore from.
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.
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.
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.
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.
Restoring From MS SQL Server 2000 Full On-Demand Backups
Warning: MS SQL Server 2000 is no longer supported by MetaCommunications products. This information is retained for customers using older versions.
Open Microsoft SQL Server 2000 Enterprise Manager, log in, and navigateto the database you want to restore.
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.
Select All Tasks, then Restore Database... in the context menu (see above). The Restore Database window will open.
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.
Select the “From device” radio button. The Restore Database window will change to the device view.
Click Select Devices.... The Choose Restore Devices window will open.
Click Add.... The Choose Restore Destination window will open.
Click Browse ( ). The Backup Device Location window will open.
Browse to and select the backup file from which you will restore thedatabase. (See screen capture above).
Click OK. The Backup Device Location window will close, and the Choose Restore Destination window will return, displaying the selected backup file path in the File name field.
Click OK. The Choose Restore Destination window will close, and the Choose Restore Devices window will return, displaying the specified backup file in the Device name list.
Click OK. The Choose Restore Devices window will close and the Restore Database window will return, displaying the selected database backup file in the Devices field.
Click the “Restore backup set” radio button. (See screen capture above.)
Click the “Database - complete” radio button. (See screen capture above.)
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.
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.
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.
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.
E-mail
