Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
EugeneLim11
Posting Yak Master
167 Posts |
 Posted - 2009-04-17 : 02:44:38
|
| Hi Experts, I am hosting a web application online, and I would like to mirror the MSSQL 2005 database locally so that in case of problems, at least we have a business continity plan -> can move database to another web hosting services.Currently, what my supervisor asked me to do is to daily backup the database, and restore the database every day (overwritting the current one) to get the latest database. My question is.1. Is it possible to automatically restore the backup database? If so how do I do this? I have managed to automatically set it up so that it will automatically backup every day and transfer the backup to a predefined location on my hard disk. 2. Or it more effective to mirror the live database? What is involved in this step and how do I configure it so that I can receive the latest database in case of problems. Thank you for your help in advanceEugenecheck out my blog at http://www.aquariumlore.blogspot.com |
|
|
avalon99
Starting Member
3 Posts |
Posted - 2009-04-17 : 06:34:41
|
| Base on what you are saying, it would be best do to a SQL clustering with a transactional replication and using the clustering as fail over. I my self am planning to do that but has not done it yet. This is for my opinion the utmost you can do for MSSQL since there is no real load balancing, and since your priority is simply disaster recovering. Some higher experts would need to shed light to both of us on how to do the details of what I said. :) |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-18 : 00:24:54
|
| How critical is the data ? How high is transaction rate? Does it have to be automatic failover? |
|
|
|
|
|
|
How to mirror a database