Database Administration
Install SQL Studio Manager
1.0 Introduction Doors.NET installation does not automatically install SQL Studio Manager (which is required for administering the database or for detaching/attaching a database backup). 2.0 Download the Studio Manager Setup File On the final screen ...
Upgrade the Installed SQL Version
1.0 Introduction Windows 11 requires Doors.NET to use SQL/SQL Express 2019. Any upgrade installations will use the SQL version that was installed at the time of installation (this will typically be SQL 2016). For this reason, SQL will need to be ...
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 ...
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 ...
Detach/Attach a Doors.NET Database
1.0 Introduction This document explains how to detach a Doors.NET database - (so it can be copied to a backup location and used for migrating a system to a different host PC/Server), It then explains how to attach a Doors.NET database. Typical ...
Manually Installing a Doors.NET Database
Creating a new database using InstallDHSDB. When you install the Doors.NET software there is a utility automatically created in the C:\Keri\DoorsNET directory. This utility can be used to manually install the Doors.NET database, such as for a ...
Doors.NET Password Recovery Request
Please submit all password recovery requests via the following web page: https://kerisys.com/password-recovery-request The online request form makes it easier for Keri to keep a record of all password recovery requests – the requested data is easier ...
Doors.NET - Migrating a System
1.0 Introduction There are several steps that need to be taken to successfully transfer a Doors.NET installation onto a different host PC. It is important that these steps are performed in the exact order that they are listed: Note: The version of ...
Generic Database Import (Excel Spreadsheet)
1.0 Introduction Doors.NET comes with a generic import utility that can be used to import card data from an Excel (XLS or XLSX) spreadsheet. This is not a licensed feature so it can be used free-of-charge with Doors.NET. 2.0 Configure the Import ...
Restore the Doors.NET Database
Instructions for Restoring the Doors.NET SQL Database Notes: - performing this task will completely overwrite ALL data in the existing Doors.Net database. - this backup procedure pertains to Doors.Net databases using Microsoft SQL Server 2016 ...
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; ...
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 ...