Realtime Backups
-
Hi all, My web application base on money transactions. My client wants to keep a realtime backups. That means i host the web app in one server and have another server for backups. If system down in the hosted server there is a backup link to the system in backup server. The problem is i want to update the backup server database in the same time when updating the original server database. What is the best and more efficient solution for this requirement. thanks
-
Hi all, My web application base on money transactions. My client wants to keep a realtime backups. That means i host the web app in one server and have another server for backups. If system down in the hosted server there is a backup link to the system in backup server. The problem is i want to update the backup server database in the same time when updating the original server database. What is the best and more efficient solution for this requirement. thanks
If your requirement is not to loose data in case of a disaster, have a look at database mirroring, especially synchronous High-safety mode: http://msdn.microsoft.com/en-us/library/ms191456.aspx[^]
The need to optimize rises from a bad design.My articles[^]
-
Hi all, My web application base on money transactions. My client wants to keep a realtime backups. That means i host the web app in one server and have another server for backups. If system down in the hosted server there is a backup link to the system in backup server. The problem is i want to update the backup server database in the same time when updating the original server database. What is the best and more efficient solution for this requirement. thanks
This is a standard setup for a high a proficiency site, you need mirroring (as Mika suggested) and more probably failover web and database servers. I would suggest talking to a hosting site, it may be simpler to pay someone else to do these.
Never underestimate the power of human stupidity RAH
-
This is a standard setup for a high a proficiency site, you need mirroring (as Mika suggested) and more probably failover web and database servers. I would suggest talking to a hosting site, it may be simpler to pay someone else to do these.
Never underestimate the power of human stupidity RAH