Miscellaneous

Restoring a database backup

Because Digita Practice Advanced utilizes a Microsoft SQL database, there are special considerations when restoring a backup of a database. The procedure below outlines how to restore a database through the Digita Practice Advanced application.
note
If you are running Digita Practice Advanced through Digita Virtual Office, the Restore command is not available. To restore your data, please call Digita Support at 01395 280 200 and follow the prompts for Web Services Support.
To restore a Digita Practice Advanced database, follow these steps.
  1. Copy the backup file to any location on your database server.
    note
    • To restore a SQL database, the backup file must reside on the database server.
    • After you make a backup, you may need to place the .BDF file within your SQL data structure — and not in the root of C: on the server — before you try to restore it. The default path is C:/Program Files (x86)/Microsoft SQL Server/MSSQL_10_50.xxx/MSSQL/Data.
  2. Choose File > Restore.
  3. In the
    Backup file\directory
     field, enter the path, and optionally, the file name, of the database backup, or click the More button and navigate to the file.
    note
    • Backup files have a file extension of BDF or BAK.
    • The backup file must be saved on the drive where SQL is installed.
  4. Enter a new name for the database in the
    New Firm name
     field.
    note
    • It is necessary to enter a new name for the database, because the application does not overwrite existing databases and does not allow two firm databases with the same name.
    • If you
      do
       want to restore a database using the same name as an existing database, you must first open the existing database, delete it (File > Delete Firm), open another database (such as Sample), choose File > Restore, and select the database you want to restore.
  5. From the list at the bottom of the Restore dialog, select the database you want to restore.
  6. Click OK.
  7. At the confirmation that the database has been restored, click OK.

This article applies to:

  • Product: Digita Practice Advanced