DCN-NG database backup & restore

[#1]

DCN-NG Database Backup

1. Note the name of the database files that need to be backed up. To check what those files are called, open the “Bosch DCN Conference Software Server Console” from the Windows notification area and note the name of the active database.
2. Shut down all DCN-NG-related programs like ‘DCN-SW Operator Application’ and ‘DCN-SW Configuration Application’.
3. Stop the DCN-NG service;
   1. Press the Windows button and search for ‘Services’
   2. Open the Windows Services window
   3. Select the service called ‘DCN-SW Server (DCNNG)
   4. Right click and choose ‘Stop’.
4. Still in the Services window, stop the services ‘SQL Server (SQLEXPRESS)’ and ‘SQL Server VSS Writer’ in the same way as outlined above.
5. Open the folder that contains the DCN-NG database. On Windows 7 and 10, it’s located by default at “C:\Program Files\Microsoft SQL Server\[MS SQL Express version]\MSSQL\data”.
   1. Replace the line between [] with the right name, this can change. Right now it’s ‘MSSQL10_50.SQLEXPRESS’
6. Make sure that the user that is logged in is able to read/write from/to this folder. If this is not the case, the following step will not work.
   1. It’s possible to change permissions to folders for users within Windows, but that’s outside the scope of this document. Logging in to the server with an administrator account should be sufficient.
7. Copy the right files to a safe location – make sure to copy both the file with extension ‘mdf’ as well as with the extension ‘ldf’.

DCN-NG Database Recovery

Short version: simply follow the backup steps, but copy the files back to the database folder.

1. Shut down all DCN-NG-related programs like ‘DCN-SW Operator Application’ and ‘DCN-SW Configuration Application’.
2. Stop the DCN-NG service;
   1. Press the Windows button and search for ‘Services’
   2. Open the Windows Services window
   3. Select the service called ‘DCN-SW Server (DCNNG)’
   4. Right-click and choose ‘Stop’.
3. Still in the Services window, stop the services ‘SQL Server (SQLEXPRESS)’ and ‘SQL Server VSS Writer’ in the same way as outlined above.
4. Open the folder that contains the DCN-NG database. On Windows 7 and 10, it’s located by default at “C:\Program Files\Microsoft SQL Server\[MS SQL Express version]\MSSQL\data”.
   1. Replace the line between [] with the right name, this can change. Right now it’s ‘MSSQL10_50.SQLEXPRESS’
5. Make sure that the user that is logged in is able to read/write from/to this folder. If this is not the case, the following step will not work.
   1. It’s possible to change permissions to folders for users within Windows, but that’s outside the scope of this document. Logging in to the server with an administrator account should be sufficient.
6. Copy the right files back to the database folder  – make sure to copy both the file with extension ‘mdf’ as well as with the extension ‘ldf’.
7. Start all services once more; ‘DCN-SW Server (DCNNG)’, ‘SQL Server (SQLEXPRESS)’ and ‘SQL Server VSS Writer’.
8. Run the ‘Repair’ function from the DCN-SW installation package.
9. The Repair Wizard will run through the procedure of creating a new database or selecting an already existing one. Choose the existing database;
10. If the repair process is successful, the following window will be shown:
11. The “Bosch DCN Conference Software Server Console” from the Windows notification area will show the system is running correctly: