Backing up a Smart Instrumentation Database on SQL Server - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Configuration and Maintenance Guide (2019)

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Administration & Configuration
Version_SPI_custom
13.1

The instructions in this procedure apply to SQL Server 2014.

The following procedure describes how to back up your Smart Instrumentation database on another server. You start the procedure by running the MS SQL Server Management Studio on the source server where you create a new dump device that will be used for your backup. Then, you back up your database to the new dump device. This allows you to copy the dump device data file to another server, which completes the backup procedure.

You cannot include the existing user-defined database views in your database backup. To be able to use these views, you must make a separate backup of all your user-defined database views before backing up your database. Then, after restoring the database, you need to re-create the user-defined views using InfoMaker or the database utilities of your platform.