The Insight installation requires two databases to reside on the SQL Server:
- Insight
- Insight_Archive
- An Insight project might also include the Insight_Construct, Insight_OFML, Insight_ABCNest, and other databases depending on the scope of the project.
NOTE: If the Insight_Archive database does not exist, you can restore it from a copy provided by Cyncly, as described in Prepare SQL Databases topic in the New Installation section.
Backing up Insight Databases
We strongly recommend that you back up all databases and store them in a known safe location prior to upgrading your Insight system.
Performing a backup
NOTE: Repeat the following steps for the Insight database and all other databases that you use.
- Open Microsoft SQL Server Management Studio.
- Point to the Insight database and right-click.
- Point to Tasks and select Back Up.
- Complete the following steps in the Back Up Database dialog box:
- Verify the database source name and backup name.
- In the Destination field, verify the backup file name or add a new one.
- When complete, click OK.
- In the Backup completed successfully dialog box, click OK.
NOTE: Repeat the preceding steps for the Insight_Archive database and other databases that you use.