Skip to main content

Restoring on the same WIN-911 machine

This method will be used to restore a previous database backup on the existing WIN-911 system. Please be aware that this restore will overwrite the existing WIN-911 Configuration databases.

  1. Open SQL Server 2014 Management Studio found in your Start menu.

  2. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine (‘[COMPUTER NAME]\WIN911’ by default), in Object Explorer, click the server name to expand the server tree.

  3. Expand Databases, and select one of the WIN-911 Module databases.

  4. Right-click the database, point to Tasks, then point to Restore, then click Database. The Restore Database dialog box appears.

    image6.png

  5. Simply clicking OK will restore the latest backup file, overwriting the existing database.

    image7.png

  6. If you would like to restore to an older backup, click the Timeline button. The Backup Timeline dialog box appears. The last backup taken is selected by default. Click Specific date and time to manually select an older backup from a specific point in time.

    A screenshot of a computer AI-generated content may be incorrect.

  7. Repeat the steps in the previous section for the rest of the WIN-911 Modules. All modules of the WIN-911 system must be restored at the same time to ensure system-wide data integrity.

  8. After you have restored all databases, you must restart the WIN-911 Runtime Services.

    To restart the WIN-911 Runtime Services, open the Windows Service applet and start each of the WIN-911 Runtime Services. See section – Preparing the Databases for Backup, for a complete list of the WIN-911 Runtime Services.

In this section: