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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 what is the process for Disaster recovery

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2009-08-21 : 18:09:47
Hi All,
i've faced an interview question, that what are your steps for setting up Disastor recovery.

please refer me some document

thanks in advance

Arnav
Even you learn 1%, Learn it with 100% confidence.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-08-22 : 12:26:56
This is a complicated topic where there is no one answer. It comes down to SLA's of the business and what they can afford. The cost goes up exponentially as the "recovery time" goes down. So companies need to strike a balance somewhere in the middle where they allow some more RTO to lower the cost. You can start from Log shipping (least expensive) to SAN Replication (most expensive that I have seen so far).

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -