During SQL DB upgrade - what needs to be cared

Hi,

SQL team planned a upgrade for 2 remote database which belongs to one of our BIGFIX root server & 2nd for 1st DSA server, during this activity 2nd DSA keep on running as its supported by one another remote DB.

So my question is there anything which I need to take care on BIGFIX servers, like DSA replication etc.

Anyone, please suggest on this.

Hi @vk.khurava,

You might want to check this document: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Endpoint%20Manager/page/Server%20Migration

It talks about server DB migration but the checklists can be used when doing DB upgrade as well.

Please make sure that the DB meets the requirements for your BigFix environment: https://www.ibm.com/support/knowledgecenter/SSQL82_9.5.0/com.ibm.bigfix.doc/Platform/Installation/c_database_requirements.html

UPDATE:
9.5.3 now supports MSSQL 2016: BigFix 9.5 Patch 3 is now available

Hope this helps! :slight_smile: