1.0 Introduction

The following procedure explains how to back up the full database automatically onto a remote memory device (such as a thumb drive/memory stick) and then how to restore the database onto a new computer. Keep in mind the new computer will require you to install the latest version of the Doors.NET software (including the default SQL database) and then for you to obtain a new Doors.NET software license; you cannot use the same license that was on the old computer.

 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 default, scheduled backup is enabled and is configured to create a backup at 23:00 every Friday.

The following procedure explains how to back up the full database automatically onto a remote memory device (such as a thumb drive/memory stick) and then how to restore the database onto a new computer. Keep in mind the new computer will require you to install the latest version of the Doors.NET software (including the default SQL database) and then for you to obtain a new Doors.NET software license; you cannot use the same license that was on the old computer.

2.0 Creating the Backup

1. From the Start Menu go to All Programs >> Doors.NET >> License Manager (or from the C:\Keri\DoorsNET directory).
   
   
   
   
2. Click on Application Server from the list of installed components on the left (it should be highlighted in green).
   
   
   
   
3. Click the Settings button on the right.
   
   
   
   
4. Click on the Backup tab.
   
   
   
   
5. Verify that 'Enable Automatic Database Backup' is selected.
6. Enter the time of day that you wish the backup to be created (as you will see, the default time is 23:00).
7. Select a day that the backup will be performed (as you will see, the default day is Friday).
8. Make a note of the backup filepath (by default, you will see that the default backup location is C:\Keri\DoorsNET\Backups.
   
   
   
   
9. Use the default file path for the backup file to be saved, or specify a new location, such as an external hard drive or USB thumb drive.
   
   Note: When using a thumb-drive, be aware that the drive letter may change if plugged into a different port than originally used during configuration.
   
   
10. Click the Save button.
11. Click Yes to the prompt to restart the Application Server Windows Service.
12. If the software is open at the time the scheduled backup occurs, there will be backup events generated in the Live Events grid.
    
    
    
    
13. As well as the specified backup folder location a copy of the database will also be save in C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup (as shown in the image above in the detail field).
    
14. Check the USB drive to ensure the backup file has been created.
15. If a backup file already exists in the specified file location of the License Manager, this old file will automatically be overwritten with the new one.
    
    

3.0 Advanced Setup - Using System Calendar

Note: System Calendar is a system-add-on that must be purchased and enabled on your license. It is not included with the standard version of Doors.NET.

1. Click the System Calendar icon in the ribbon bar.
2. Click the New Appointment icon.
3. Input a description in the subject text field.
4. Input a start time for when you want the automatic backup to take place. An end time is automatically created which does not need to be altered.
5. Click on the Categories tab.
6. Select Backup.
7. Go to the Start Action tab and put a check mark against 'Full Backup'.
8. Click the Save and Close link.
9. Click the Save All icon in the upper left corner.
10. The Appointment description and time will appear in the appointments list.
    
    
    
    
11. At the Start time an event will appear in live events: "A database backup process has started", followed by "A database backup process has completed".
    
    
12. You can find the backup (.bak) file by navigating to the following location on a default installation: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
    
    

4.0 Restoring the Database

4.1 Delete the Default Database

1. You will need to install the Doors.NET software on the new PC. During the installation you should select to install the default database – this is the quickest method of installing the required SQL database instance and associated username and password that are used to connect to the restored database.

2. Once software has installed open up SQL Studio Manager via the start menu. You should right-click on the icon and select to: “Run as administrator” to avoid any possible permissions issues.
   
   
   
   

3. Click the Connect button on the login window.

4. Double-click Databases on the left.

5. You should see the Doors.NET database listed. It will be named DHS_MAIN.
   
   
   
   

6. Right-click DHS_MAIN and select Delete.
   
   
   
   
7. Place a checkmark against ‘Close existing connections’. Then click OK.

8. The database files will automatically be detached and deleted from the host PC. Ready for you to restore the backup database.

4.2 Restore the Backup Database

1. Insert the USB/thumb drive into the new PC.

2. Log into Studio Manager again if you are not still logged in.

3. Right-click Databases and choose Restore Database.
   
   
   
   

4. Select ‘From Device’ then click on the browse button.
   
   
   
   

5. On the Specify Backup window, click the Add button.

6. Locate the drive for the USB/thumb drive. It is likely to be at the bottom of the list.

7. Double click the drive.

8. Open the folder which contains the backup file.

9. Select the database backup file then click OK.
   
   
   
   

10. Click OK again on the Specify Backup window.

11. Place a checkmark against Restore and at the top of the Restore Database window select the database backup name from the drop-down list.
    
    
    
    
12. Click the OK button and the database restoration will begin.