InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 12:26:01 GMT20http://www.sqlservercentral.com/Forums/Topic1364336-384-1.aspxHere is a good primer to set you in the right direction asking the important questions:[u][url=http://www.brentozar.com/archive/2009/12/designing-a-recovery-strategy-for-stackoverflow/]Designing a Recovery Strategy for StackOverflow (December 16, 2009) by Brent Ozar[/url][/u]Wed, 26 Sep 2012 07:49:19 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1364336-384-1.aspxStart with your SLAs. What is the RPO for that database (recovery point objective, or how much data may be lost)? What is the RTO (recovery time objective or how long the DB needs to be down)Without those, there is no DR plan that can even be considered.Wed, 26 Sep 2012 04:23:18 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1364336-384-1.aspxIt's a giant topic. But, as with everything else SQL Server, [url=http://msdn.microsoft.com/en-us/library/ms178094(v=sql.105).aspx]start with the Books Online.[/url] Microsoft Developers Network (MSDN) also has [url=http://support.microsoft.com/kb/169039]an example of a plan[/url]. And finally you can always [url=http://www.simple-talk.com/sql/backup-and-recovery/disaster-recovery-for-sql-server-databases-/]rely on Simple-Talk[/url] to have a few articles on any topic within SQL Server.Those just scratch the surface of what's out there for this type of thing. They don't even get into using high availability and disaster recovery solutions from your SAN vendor. They don't cover some of the new HA & DR options with virtual machines either.It's a HUGE topic. I won't be able to provide you with enough links here to provide a truly meaningful answer. I'm with the last post, what specifically are you after?Wed, 26 Sep 2012 03:46:03 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1364336-384-1.aspx[quote][b]harri.reddy (9/25/2012)[/b][hr]hii need to know ,what will you do for disaster recovery for your database.i need any article and anything you have .thanks[/quote]:blink:You're not talking articles here, you're talking books and blogs and all sorts of information all over the place. This isn't a quick read subject, you're talking a month or two of dedicated research into options, choices, pros and cons, methodology, and all sorts of other things.What's driving this? The more information we have the more we can help direct you to the specific resources you're going to need. This is equivalent to asking "Describe the coolant plumbing of a nuclear reactor". At the surface it looks simplistic, but yeah, it's not.Tue, 25 Sep 2012 16:14:58 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1364336-384-1.aspxhii need to know ,what will you do for disaster recovery for your database.i need any article and anything you have .thanksTue, 25 Sep 2012 16:08:20 GMTharri.reddy