Restore a backed up database – TREND 963 User Guide User Manual
Page 80
Using 963
963 User Guide TC200635 Issue 3 25/03/2008
80
3.17.2.4 Restore a Backed up Database
If 963’s database has been backed up it can be restored if there is a problem e.g. the database becomes corrupt.
To restore a backed up database:
1. Log in as described in the ‘Log In’ section of this manual.
Note that if running 963 Secure you must be in the ‘System Administrator’ workgroup.
2. On the Database menu click Properties. The Database Properties dialogue box is displayed.
3. Ensure that the Detach database after Supervisor has been shutdown check box is selected.
4. Select the Restore database when Supervisor restarts check box. A dialogue box is displayed prompting
you to restart 963.
5. Click OK. to close the dialogue box and return to the Database Properties dialogue box.
6. Click OK to close the Database Properties dialogue box. A dialogue box is displayed reminding you that
you need to restart 963.
7. Click OK.
8. Close 963 as described in the 'Close 963' section of this manual.
9. Rename the files 'i96x_data.mdf' and 'i96x_log.ldf' located in 963's database directory.
10. Run 963 as described in the 'Run 963' section of this manual. As 963 restarts a dialogue box is displayed
asking if you want to restore a previously backed up database.
11. Click Yes. The Open dialogue box is displayed.
12. In the folder list box click the required database. To select a database in a different location, click the
drive, or folder in the Look in box that contains the file, and double-click the folders in the folder list until
the required location is displayed.
The database backup file contains a reference to the original location of the database. 963 is unable to
restore the database to a different location than the one specified in the ‘dat’ file. This means that if you
are attempting to restore a database it must be to the same directory path as the original.
12. Click Open. The database will be restored. A dialogue box is displayed once the database has been
restored.
13. Click OK.