Moving Metasys Historical Databases to a Custom Location - Metasys - LIT-12012162 - MS-ADS05U-0 - MS-ADX100SQL2-0 - MS-ADX100U-0 - MS-ADX10SQL-0 - MS-ADX10U-0 - MS-ADX25SQL-0 - MS-ADX25U-0 - MS-ADX50SQL-0 - MS-ADX50SQL2-0 - MS-ADX50U-0 - Server - Metasys Server - 11.0

Metasys Server Installation and Upgrade Instructions

Product name
Metasys Server
Document type
Installation Guide
Document number
LIT-12012162
Version
11.0
Revision date
2021-07-02
Product status
Active

By default, the Metasys Server software and databases are installed to the C: drive. You can move the Metasys historical databases to a different location after you install the Metasys software. Follow the steps in this section.

  1. Stop the Metasys III Device Manager service. Open Windows Task Manager. Click the Services tab. Right-click the MIIIDM service and click Stop Service.
  2. On the computer that hosts the databases, open SQL Server Management Studio and connect to the database engine computer.
  3. In the Object Explorer, expand the Databases folder.
  4. For each Metasys historical database, right-click on the database and click Properties. The Database Properties window appears.
  5. In the Select a page pane, click Files. Record the paths listed in the Path column of the Database files table. Click OK to close the Database Properties window.
  6. In the Object Explorer, right-click on the database. Select Tasks > Detach. The Detach Database window appears.
  7. Select the Drop Connections checkbox. Click OK.
    Note: A message may appear stating that the database is in use. If this message appears, ensure all Metasys applications are closed and the Metasys III Device Manager service is stopped.
  8. Move the .mdf and .ldf database files to the new drive location.
  9. After moving the Metasys historical databases, reattach the databases. In the Object Explorer, right-click the Databases folder and click Attach. the Attach Database window appears.
  10. In the Attach Database window, click Add. The Locate Database Files dialog box appears.
  11. Browse to the new location of the databases. Select the databases and click OK.
  12. In the Attach Database window, click OK. The databases are now attached.
  13. If the Metasys historical databases do not appear under the Database folder in the Object Explorer, right click the SQL folder (database engine computer node) and select Refresh.

For Johnson Controls technicians: Refer to FSC Solutions Database Article 30393 for instructions on using a SQL script to complete this procedure.