SQL Server

For more details regarding backup and restore in SQL Server, see Microsoft's documentation.

Assumptions

The procedures in this section were developed based upon the following assumptions:

  • The VoiceConsole database is using the simple recovery model.
  • VoiceConsole On Prem deployment 6.2.1 is installed on the server to which a database is being restored. The instructions below include stopping the VoiceConsole On Prem deployment 6.2.1 service on the machine to which the database is being restored.
  • This document addresses the architecture of a primary server with VoiceConsole On Prem deployment and the database installed on the same server, and one or more backup servers with VoiceConsole On Prem deployment and the database installed. If a different architecture is being used, then some of the steps are different.
  • The database cannot be in use during the time of a restore operation; so any instance of the VoiceConsole On Prem deployment 6.2.1 service pointing to the database being restored must be stopped.
  • The restore operation is always restoring an existing VoiceConsole database. The procedures listed below do not address restoring the database to a database server on which there is no existing VoiceConsole database. This is possible, but the procedure is not covered in this document.

How to Create a Backup of the VoiceConsole Database

  1. Open SQL Server Management Studio and connect to the database server.
  2. Click Databases.
  3. Right-click on the VoiceConsole database (the actual name is whatever was chosen at install time).
  4. Select Tasks.
  5. Select Back Up. The Back Up Database window appears.
  6. In the Backup type drop-down list, select Full.
  7. For Backup component, select Database.
  8. In the Backup set section, enter a name for the backup, or accept the default.
  9. Enter a description, if desired.
  10. In the Destination section, select Disk for Back up to.
  11. Accept the default destination, or use the Add and Remove buttons to specify a different destination.
  12. In the Select a page navigation bar on the left, select Options.
  13. In the Overwrite media section, select Back up to the existing media set.
  14. Select Overwrite all existing backup sets.
  15. In the Select a page navigation bar on the left, select General.
  16. Click OK at the bottom of the window. The progress meter at the bottom left of the window indicates the status of the process.
  17. When the backup is complete, click OK to close the Back Up Database window.

How to Schedule a Backup of the VoiceConsole Database

  1. Follow the steps in How to Create a Backup of the VoiceConsole Database.
  2. On the menu bar at the top of the Back Up Database window, select Script > Script Action to Job. The New Job window appears.
  3. On the General page, change the name of the job, the owner, and description if desired, or accept the default settings.
  4. In the Select a page navigation bar on the left, select Schedules.
  5. Click the New button at the bottom of the window. The New Job Schedule window appears.
  6. In the Name field, give the schedule a name.
  7. Make sure that the Schedule type is set to Recurring.
  8. Use the rest of the fields in this window to set the schedule and time that the backup is to run. Honeywell recommends backing up the database daily and scheduling the backup to run at a time of light system usage.
  9. When you are done configuring the schedule, click OK in the New Job Schedule window.
  10. In the New Job window, click OK. The script that creates the backup is to run. The progress meter at the bottom of the Back Up Database window indicates the status of the process.
  11. When the process is complete, click Cancel at the bottom of the Back Up Database window to close the window.
  12. Verify that the backup job was created by expanding SQL Server Agent, and then expanding Jobs. The new backup job appears.

How to Restore the VoiceConsole Database

How to Restore a Backup of the VoiceConsole Database to the Server on Which the Backup was Created

  1. VoiceConsole On Prem deployment needs to be stopped to restore the database. The application is unavailable while the database is being restored.
  2. Select Start > Control Panel > Administrative Tools > Services.
  3. Select the VoiceConsole On Prem deployment service, and stop the service.
  4. Open SQL Server Management Studio, and connect to the database server.
  5. Expand Databases.
  6. Right-click on the VoiceConsole database (the actual name that was chosen at install time).
  7. Select Tasks.
  8. Select Restore.
  9. Select Database. The Restore Database window appears.
  10. The default settings should be correct. Click OK. The restore process begins. The progress meter at the bottom left of the window indicates the status of the process.
  11. When the process is complete, click OK to close the window.
  12. Start the VoiceConsole On Prem deployment service.

How to Restore a Backup of the VoiceConsole Database to a Different Server Than the One on Which the Backup was Created

  1. Copy the backed up database file to the server to which the backup is to be restored.
  2. Select Start > Control Panel > Administrative Tools > Services.
  3. Select the VoiceConsole On Prem deployment service, and stop the service.
  4. Open SQL Server Management Studio, and connect to the database server.
  5. Expand Databases.
  6. Right-click on the VoiceConsole database (the actual name that was chosen at install time).
  7. Select Tasks.
  8. Select Restore.
  9. Select Database. The Restore Database window appears.
  10. In the Source for restore section, select From device.
  11. Click the ... button. The Specify Backup window appears.
  12. For Backup Media, select File (.bak).
  13. Click the Add button to navigate to the location of the backup file.
  14. Browse to the backup file, and click OK. The backup location is now listed in the Specify Backup window.
  15. Click OK.
  16. In the Select the backup sets to restore table, check the box in the Restore column for the backup.
  17. In the Select a page navigation bar on the left, select Options.
  18. Select the check box for Overwrite the existing database.
  19. All other settings should be correct. Click OK at the bottom of the Restore Database window. The restore process begins. The progress meter located in the bottom left corner of the window indicates the status of the process.
  20. When it is complete, click OK to close the Restore Database window.

For this procedure to be successful, you must perform the following steps.

  1. SQL Server logins have a unique Security ID (SID) that belongs to a particular instance of SQL Server.
  2. If there are any users in the VoiceConsole database, you must update the user records in the restored database so that they refer to the SID of the corresponding SQL Server login on the instance of SQL Server on this server.
  3. Run the following command against the VoiceConsole database in SQL Query Analyzer to find users that must have the SID changed: 
    EXEC sp_change_users_login' Report'
  4. If any records are returned, run the following command for each user returned: 
    EXEC sp_change_users_login
    'Auto_Fix', username
  5. where username represents the user name that needs to have its SID fixed.
    The command should display the following output indicating that the user's SID was fixed:
    The row for user "voice_console_db_22" will be fixed by updating its login link to a login already in existence. 
    The number of orphaned users fixed by updating users was 1. 
    The number of orphaned users fixed by adding new logins and then updating users was 0.
  6. Start the VoiceConsole On Prem deployment service.