Does anyone have a Warm Backup situation with their AC.
What I mean is if the server holding the AC database goes down, what is the plan for bringing things up fast.
I have done the following
1) Installed another machine with sql express(installed AC on it with local db option)
2) Have a job that continously keeps copying the imported folder 3 times a day.
3) I have a shadow copy of the origional database files being copied to another folder on the network.
4) 3 times a day I copy the shadow copy db files from the backup location to backup machine.
3) On the Stop the sql service, copy the mdf files ( for user databases) and then restart the service. This happens
Now if the main server dies, then I can just ask the staff to point thier AC installation to the new machine by selecting the amazingcharts.xml file and they are up and running.
I am a part time IT for the staff. So I hate when I am in a meeting and getting a SMS from staff that computer is down and I have to scramble. 2 days ago my network card went down. It too me while to replace that etc.
Basicaly what I am doing in old time log shipping.
