We had an unexpected power down last week and the company failed over to our backup servers and DBs.
The db's connection string was to the proimary DB and could not connect to our backup DB server and I was unable to log in and change the connection string and had to wait for access to the actual server and change it, this took quite some time (company policy hey).
Any way my question is there a way to have my DNN site inteligently try to access another db (backup connection string perhaps) if it is unable to connect to the main one that I have stipulated ?
Beside Sebastian's suggestion of an SQL Server Cluster there are other possibilities as well, but it is always done in SQL Server and not in DNN.
One way to achieve this is Log Shipping, the other one is Always On availability groups. All of these have their pros and cons.
Happy DNNing! Michael
Michael TobischDNN★MVP
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.