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