Home > IT Answers > SQL Server > Disaster recovery for SQL 2005
NewnanIT
1,110 pts.
 Disaster recovery for SQL 2005
SQL Server 2005, SQL Security, SQL Server 2005 security, SQL Server 2003, Replicating databases, SQL Backup, Disaster Recovery
How can we setup a disaster recovery sql server? We are running SQL 2005
on a 2003 box. We need a real time exact replica we can switch to?
ASKED: Oct 6, 2010  4:58 PM GMT
UPDATED: October 7, 2010  3:05:15 PM GMT
RELATED QUESTIONS
Mrdenny
63,630 pts.
Answer Wiki:
That all depends on how much data you can afford to loose and what sort of systems you have in place.

For a small business the most common solution would be to use database mirroring to replicate the database to a DR site.

Larger companies will use storage based replication or something similar to replicate the data.

The first question in any DR discussion is how much data can you afford to loose and how much money do you have to spend on the solution. The smaller the first number, the larger the second number will need to be.
Last Wiki Answer Submitted:  Oct 7, 2010  3:05 PM (GMT)  by  Mrdenny   63,630 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

[...] 4. Mr. Denny gave an in-depth answer to a member struggling with disaster recovery for SQL 2005. [...]

The Most-Watched IT Questions: October 19, 2010 - ITKE Community Blog
 0 pts.