It is sometimes necessary to move a Runtime database from one Historian Server computer to another. Tech Note #817 Moving the Historian Runtime Database From one Machine to Another describes this process for SQL Server 2005 and SQL Server 2008; however, several of the stored procedures used in that Tech Note have been deprecated in SQL Server 2012.

This Tech Note provides step-by-step procedures to guide you through this process using SQL Server 2012 and later.

Application Versions

  • Historian Server 11.0 or later
  • Microsoft SQL Server 2012 (32-bit or 64-bit)

Note: This Tech Note assumes that you are familiar with Wonderware Historian Server and Microsoft SQL Server Management Studio. If you have any questions regarding the Microsoft SQL Server, contact Microsoft Technical support at www.microsoft.com for further assistance.