ARCHIVED
The jncc.defra.gov.uk website has now been archived. For the latest information from JNCC, visit jncc.gov.uk

16 Database Tools

 
 
 
 
 
 
The database tools in Recorder 2002 include options to compact and repair the databases.  These are functions for Access databases and hence are not applicable to Recorder 6.  The equivalent of Compact in a SQL Server environment is ‘Shrinking’ the database.  For more information see the Optimisation section in the Network Installation Guide.
 

Backups

To back up your database in Recorder 2002, you could simply copy the nbndata.mdb file to another location.  This is not the case in Recorder 6, the database cannot simply be copied and pasted to a new location, so to facilitate backups, additional functions have been provided:

 

  • Tools – Database Tools – Backup Database
  • Tools – Database Tools – Restore Database
  • Tools – Database Tools – View or Change Backup Location

 

In a standard standalone installation, a backup done this way will be a file called NBNBackup.bak stored in the Temp folder for the user who installed Recorder 6, e.g. C:\Documents and Settings\Sally Rankin\Local Settings\Temp, however this may vary.  Also, users can change this using the option to change the backup location.  This facility specifies where Recorder 6 is expecting to place the backup which needs to be consistent with where SQL Server is expecting to place it.  Note that because of its size a backup will need to be zipped before it can be written to a standard CD.

 

In SQL Server systems, for security purposes, it isn’t possible to do things like take copies of databases while they are attached to a SQL Server instance.  If users need to take a copy of their database, e.g. to transfer to a new computer or to seek help with diagnosing problems, they must first ‘detach’ it from the SQL Server Instance.  On the new computer or when the database has been returned to them they would then need to ‘attach’ it.  Recorder 6 won’t run while the database is detached.  SQL Server tools such as SQL Server Management Studio Express are needed for these functions.  As mentioned at the end of section 2 this software can be downloaded from a Microsoft web-site.  An alternative would be to use the backup and restore facilities in Recorder 6.

 

SQL Server itself provides other options for backing up the database, e.g. automatic backups can be scheduled through SQL Server if you have the appropriate tools.  For more information see the section headed Backup and Restore in the Network Installation Guide.