[ISS Support Case] Local Historian configuration

Last updated: March 7th, 2025

Description

Attempting to follow https://softwaresupportsp.aveva.com/#/okmimarticle/docid/tn000022770 to create a Backup Local Historian. Have backed up Runtime db off of Main Historian and restored to Backup Local Historian in SQL Server. Signing into SQL Server on Local Historian as a sysadmin. Get to step 13 in the document and get attached errors when attempting to perform that step. Noticed that none of the local user accounts existed within Security Logins, but thought that the script would be creating those. Do not understand why I'm getting the errors or what to do to fix the issue.

Author: Kevin Modlin
Published: March 7th, 2025

Details:

Product: Historian

Version: 2020 R2

Solution: [Solution is visible below when you're logged in and have a current subscription]

Date Created:	03/21/2023
Case:	84004

Give feedback about this article

Recommended articles

[ISS Support Case] Historian loses connection after shutting down

If the historian is shut down and disabled then re-enabled it doesn't connect to tags that haven't changed. Reboot re-establishes connection.

[ISS Support Case] Trying to access old history blocks

They have a very old system they're trying to open a trend or see the data, but they don't see a trend program and can't figure out how to open the file. They believe they have the data, but it's running in demo mode and won't show data. This is an offline PC and they want to avoid putting it online, so we can't do a screen share.

[ISS Support Case] Trend SQL Login Failure

Client reached out due to receiving time out error message when logging into SQL to View Trends remotely on Development node.

[ISS Support Case] Wanting to pull 9 months of historized data

-Customer is wanting Historized data from the last 9 months in a .CSV file. Or in SQL. and wants to know the best practices.