Backup the Doors.NET Database

Backup the Doors.NET Database

This procedure describes a backup process for Doors.NET databases using Microsoft SQL Studio Manager 2019, however, the procedure is almost identical to other versions of SQL Studio Manager.

 

Note: These instructions specifically cover a Disc backup; Tape backup is not covered.

 

Note: Microsoft does not provide a downgrade path for SQL databases. This means you cannot, for example, use SQL 2016 or 2019 files on a SQL 2012 database engine. You can, however use SQL 2012 database files on any other newer version of SQL Server.

 

Doors.Net Database Backup Microsoft SQL Server 2019 Studio Express

Note: You do not have to stop any Doors.Net services to perform an SQL database backup.

  1. Open the SQL Server Management Studio Express application in the Windows Start Menu. You should right-click and select Run as Administrator.

    Run as Admin

  2. Log in using Windows Authentication (You must have full administrative rights on the PC to log in using Windows Authentication, if you do not then you should consult an IT professional).

    Studio Manager Connect

  3. Expand Databases on the left hand pane.

    Expand databases

  4. Right click on the DHS_MAIN database and choose Tasks > Backup.

    Select Backup

  5. The Back Up Database window will appear.
  6. In the Source section, the first backup you make should be a Full backup.
  7. Backup component should be left at the default selection of Database.
  8. The destination should backup to Disk.

    Backup Type

    Note: These instructions specifically cover a Disc backup; Tape backup is not covered. For information on Tape backups refer to your IT and/or SQL administrator.

  9. The default, selected paths are displayed in the Backup to list box. By default the backup will be saved to:

    - "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\." (32-bit)
    - "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\." (64-bit)

  10. Click the OK button and the backup will be created.
  11. The backup file will appear as DHS_MAIN.bak in the destination selected. The default destinations are:

    - C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup - on a 32-bit operating system, and:
    - C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup - on a 64-bit operating system

    DB Backup location

Note: This file can, and should, now be copied from this source location onto a removable media such as USB thumb drive.