Hi all,
Unbeknownst to me, my Orion server has been running on an evaluation version of SQL for the past few months, ever since it was migrated to a new VM. When we entered a license key for MS SQL Standard Edition, the Orion database stopped working and would not attach due to this error:
Database 'NetPerfMon' cannot be started in this edition of SQL Server because part or all of object 'LimitationSnapshots' is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition.
We have a case open with Solarwinds, but they've been unable to figure out why this is happening. We were able to bring the Orion server back up on another VM with an eval license of SQL Server (again), but would like to find a permanent fix for this. Has anyone experienced this or perhaps know how to fix it so we can get things fully operational again?