Hello, I have opened up a Support ticket on this question that I am posting as well.
I am currently looking for an HA solution for the SMP, we would be ussing CMS, Asset Management, Deployment Solutions. I was hoping that SMP would support a form of HA. I have talked to a Symantec trainer and has suggested that Database Mirrioring should work.
I have built out the Mirriorng Database with a witness.
labsql\instance1
labsql2\instance1
sqlwitness
When I manually fail over the system I see all of the SMP connections closing from the former Principal Server and re establishing new sessions to the new Principal database. Unfortunately I lose out access to pages with in the SMP Server. This seems to be something isnt working right but then again SMP is just the platform and all the pieces are all built differently. Is Database Mirroring a real option or I am just encountering something weird in general, has anybody else deployed the SMP with CMS, DS, Asset that has a functioning Database mirroring going on.
Thank you for your time.