Within our company we are upping our resilliance, migrating the umbraco database and adding 'database mirroring', the idea being that if DB-1 dies, DB-2 kicks in... Makes sense...
To enable this, our DB admin has asked me to include the 'Failover partner' in my connection string. I have found loads of info on how to do this on the net, but nothing relating to Umbraco or the web.config file.
No problem. Like with all MS products - theres masses of documentation everything - but the hard bit is finding the answer you want in the masses of docs!
Database mirroring
Hi all
Within our company we are upping our resilliance, migrating the umbraco database and adding 'database mirroring', the idea being that if DB-1 dies, DB-2 kicks in... Makes sense...
To enable this, our DB admin has asked me to include the 'Failover partner' in my connection string. I have found loads of info on how to do this on the net, but nothing relating to Umbraco or the web.config file.
Can someone point me in the right direction?
Thanks
Ben
The connection string in the web.config will be used by your database.
Providing it's MSSQL you can just append an additional value to the querystring, see here:
http://msdn.microsoft.com/en-us/library/5h52hef8.aspx
Thanks Drew - It's pretty obvious now I look at it.
No problem. Like with all MS products - theres masses of documentation everything - but the hard bit is finding the answer you want in the masses of docs!
Cheers :)
is working on a reply...