I’ve just inherited our SolarWinds environment, and I'm about to upgrade our Orion instance to HCO. When I go in to back up the database in SSMS, I get the following error:
"System.Data.SqlClient.SqlError: The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'FindFirstFile' on 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SolarWindsOrion_IN_MEM.vs\*'. (Microsoft.SqlServer.Smo)"
I checked that folder path, and SolarWindsOrion_IN_MEM.vs doesn't exist. There is a folder called SolarWindsOrion_IN_MEM. I've backed up the SolarWindsFlowStorage and SolarWindsOrionLog with no issue.
Any thoughts?