You have a web application that is in regular use. Your business depends upon being to get information from the database. Occasionally it encounters connectivity problems and is unavailable.
set up a backup database on another server - in another data center. Each night take a backup of the live database and copy it to the backup server. An automatic process can restore the database. if the web application is installed on the backup server then users can access data (read only) even if the main server is down. It also has the advantage that it provides an excellent playground for training and testing.
- The system is identical. Restore process is automatic.
- Users know the system. You should be taking a backup anyway.
- No additional development costs.