Doors.NET Database Backup to a Custom Location

Doors.NET Database Backup to a Custom Location

It has often been asked if the Doors.NET SQL database can be backed up to a custom location such as a network drive or a USB stick.

By default the backup file is created in C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup when you click the backup icon in the user interface.

 

 

It is possible via SQL Studio Manager but ONLY when using Server Express 2012. There is not a way to specify a custom database location in SQL 2005 Studio Manager. If you want to change the default location when using SQL Server 2005 then you will need to alter some registry settings but this should only be done by IT professionals.

 

The registry keys are:

 

For 32 bit OS:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory

For 64 bit OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory


You will need to restart SQL to have the changes applied.

 


Changing the backup location using version 3.5.1.21

Backup Utility in License Manager


It is also possible to change the database location if you are using version 3.5.1.21 of Doors.NET. This is performed via the License Manager and is completely supported regardless of which version of SQL Server you are using. Click here for detailed instructions.

 

Changing the backup location using Server 2012

 

  1. Run Studio Manager Express 2012 and connect to the Eclipse Server instance.
  2. Highlight the server instance in the browser pane and select 'Properties'.



  3. In the properties pane select 'Database Settings'.



  4. Locate the 'Backup' text field at the bottom of the window. It will have the default path specified. Type in the desired network location or click the browser button and navigate to an alternative backup destination.



  5. Click OK to save your changes.
  6. Click the OK button again to close the Server Properties window.
  7. When you click the Backup icon in the Doors.NET user interface (Tools >> Backup), the backup file (.bak) will then be created and sent to the custom location you have selected.

 

 

 



    • Related Articles

    • 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; ...

    • Doors.NET - Custom Installation

      1.0 Introduction A full installation installs the minimum required components for a single-PC system (the Application Server, hardware gateways, archive service and administrative client). The custom install option is used to install additional ...

    • Quick Database Backup

      Backup The backup features is a very simple means of creating a full backup of the entire Doors.NET database. There is no configuration required and the backup process completes very quickly. Click the backup icon and you will a see prompt that needs ...

    • Setup Automated Database Backup

      1.0 Introduction Doors.NET includes the ability to schedule a system backup to be automatically created once a week, every week. This is included in the standard and professional versions of Doors.NET. The feature is setup via the License Manager. By ...

    • Doors32 to Doors.NET Database Conversion Procedure

      1.0 Introduction This document provides basic information regarding the process for converting a Doors32 database/system for use in a Doors.NET access control system. It is intended to ensure that you (the customer) understand the steps you need to ...