Help and Support

Back up and restore Digita Suite databases with SQL Server Management Studio

When the Digita Database Backup Tool is not available, or you are unable to backup large databases, you can use SQL Server Management Studio to manage your backups.
Back up a database:
  1. Open SQL Server Management Studio. Log in with the administrator account or SQL Server Administrator account ('sa').
  2. Expand on 'Databases' and right click on the database you wish to backup. Follow the options below to select the Backup option.
  3. Select
    Remove
    , then
    Add
    . Failure to do this will mean the backup will append into the last backup file created.
  4. When adding a backup file, change the path to your preferred location, or use the default path. Enter a file name, followed by a '.BAK' file extension and select
    OK
    .
  5. Select
    OK
     to start the backup. You'll get a notification once it's complete.
Restore a database
:
  1. Open SQL Server Management Studio. Log in with the administrator account or SQL Server Administrator account ('sa').
  2. Right-click on
    Database
     and select
    Restore Database
    .
  3. Select the ellipsis button next to
    Device
    , then
    Add
    . Select the database you want to restore, then
    OK
    .
  4. Select the
    Options
     page and tick
    Overwrite the existing database (WITH REPLACE)
    .
  5. Select
    OK
     to restore.
Recreate SQL Server Database accounts and permissions
:
Once the databases have been restored, you will need to apply a selection of user accounts and permissions to allow the software to connect with the databases.
  1. In SQL Server Management Studio, select the database you wish to recreate the permissions in.
  2. Select
    New Query
    , enter the text Security, then select
    Execute
    .
  3. If the query runs successfully, there will be a report at the bottom of the page with no red text errors.
If the query runs successfully, there will be a report at the bottom of the page with no red text errors.
To run on additional databases, just change the drop down menu to change the database.

This article applies to:

  • Product: Companies House Accounts Filing, Digita Accounts Production