Backup, restoration, and renaming of the SQL Server databases - Metasys - LIT-12013243 - M4-OASMIN-0 - M4-OASSTD-0 - Server - Open Application Server - 13.0

Open Application Server (OAS) Commissioning Guide

Brand
Metasys
Product name
Open Application Server
Document type
Commissioning Guide
Document number
LIT-12013243
Version
13.0
Revision date
2023-10-12
Product status
Active
Language
English

Frequent backups of the SQL Server databases are necessary to maintain the integrity of your system. Examine your business needs to determine if daily, weekly, or monthly backups are necessary. The Metasys Database Manager software provides a convenient method for database backup, restoration, and renaming. For details, refer to Metasys Database Manager Help (LIT-12011202).

You can also perform database functions with the Microsoft SQL Server Management Studio tool. This software is included with the full editions of SQL Server software and available for the Express editions from the Microsoft Download Center website. Contact your Johnson Controls support representative for more information on how to use third-party applications to perform backups of individual databases.

Refer to Network and IT Guidance Technical Bulletin (LIT-12011279) for more general SQL Server database recommendations.

To avoid system problems, exclude the following files and folders from any backup procedure:

  • C:\Program Files (x86)\Johnson Controls\MetasysIII
  • C:\Program Files (x86)\Johnson Controls\MetasysIII\WS\WEB.CONFIG
  • C:\Program Files (x86)\Johnson Controls\MetasysIII\WS\BIN
  • C:\<WINNT or Windows>\Microsoft.NET\Framework\v1.1.4332\CONFIG
  • C:\<WINNT or Windows>\Microsoft.NET\Framework\v2.0.50727\CONFIG
  • C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
  • C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG
  • C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config
  • C:\Windows\Microsoft.NET\Framework64\v4.7.2\Config
  • C:\Program Files (x86)\Johnson Controls\MetasysIII\WS\GLOBAL.ASAX