What needs to be backed up prior to upgrading to a newer version of Spotlight on SQL Server Enterprise(SoSSE)?
Steps are being taken in preparation to upgrading the installation of Spotlight on SQL Server Enterprise.
We need to implement a backup solution for our SoSSE configuration and settings.
In case of an upgrade failure, the followingitems shouldbe backed up in order to maintain configurations and connections as part of a Disaster Recovery (DR) plan:
1.) On the Diagnostic Server machine, back up the folder..\agent folder.Default Location:C:\Program Files\Quest Software\Diagnostic Server\Agent\
2.) Make a Back up of both the Playback database and Spotlight Statistics Repository database (SSR).
4.) Backup any Enterprise Views. From the Spotlight GUI on the left-hand side pane under Spotlight Enterprise, you can save views as a .sev file by under the open views, right-click on the view and save as. Savethese .sevfiles to a directory covered by a proprietary backup solution.
If you would like to migrate the connections for the previous version and the latest version, See SOL48759.