BigFix Compliance recovery

Usage and Config Security
1

Hi BigFixer’s,

Recently we uninstall MS SQL Server 2012 and install MS SQL Server 2016 for BigFix server(Remote database).
Before installing MS SQL Server 2016, we took the backup of each and every database (BFEnterprise, BESReporting, BFI_TEMA) but when we tried to restore SCA_TEMA Database its not getting restored.

Is there any way to restore the same compliance module on new SQL server 2016?
Please suggest.

Thank You

2

Hi,

I would like to add more information about my activity.
After restoring BFEnterprose, BESReporting, BFI_Tema databases, our setup is working properly. Only for the compliance database we are facing issue.

Thank You

3

Is the backup file corrupt? Can you try an older backup instead?

You could certainly build a new SCA server, but you’d lose older reporting metrics and reports.