InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 19:32:34 GMT20http://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspxHi Benki,I think there are a few things that you may be missing on the answers that everyone has provided to you. I hope this answer helps you.There is a ton of potential answers to your question, we could talk about RAID levels, and how that is a DR solution for a bad disk. We could talk about hot sites, or cold sites. A DR solution has to be driven by the requirements that your customer has. You are going to have to sit down with them and help them answer the questions to make sure that it meets their requirements. Many clients are not going to understand some of the questions that you need to have answered. Things like acceptable data loss, acceptable recovery time, hot or cold site, or do you even need a DR Site.I would recommend a multiple step approach, give them an example and ask them what they would like to have done, and what they must have done to not impact the revenue to their company. Base on the answers then you can begin with the next level of requirements gathering. Your messaged stated this was for an audit requirement. What is it?If its for Audit Only and it has to be practiced every 6 months, then does a backup and restore of the databases meet the requirements? That is a very valid DR solution.Wed, 11 Jan 2012 11:42:43 GMTChris Shawhttp://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspx[quote]1 - Data loss is not appreciated..Hardly a couple of hours of data should be ok2 - Full recovery models3 - Definitely transactional based environment4 - I didn't understand this? [/quote]Sounds like logshipping would suffice for this type of scenario, and as rob has already pointed out, there are a couple other options. IMHO, the log shipping is probably the easiest to set up and get going.What I meant by #4 was if there were things like SSIS packages that perform ETL-like processes or Custom scripts, SQL Agent jobs, specific applications running on the existing DB server, and etc that you would need to take into consideration to have mirrored on the DR box - youo'd need to take that into considerationWed, 11 Jan 2012 11:07:56 GMTMyDoggieJessiehttp://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspx[quote][b]MyDoggieJessie (1/11/2012)[/b][hr]Please be more specific:1) What's an "acceptable" amount of lost data? i.e. Anything since the last full backup? 2 hours of data? 6 hour? NONE?2) What recovery modes are currently being used in this environment?3) Is this DR-scenario for a transactional-based enviornment or just for historical data (i.e a datawarehouse)?4) What dependencies/gotchas exist?[/quote]I am sorry..I didn't have much info about a lot of these questions...1 - Data loss is not appreciated..Hardly a couple of hours of data should be ok2 - Full recovery models3 - Definitely transactional based environment4 - I didn't understand this?Wed, 11 Jan 2012 08:31:26 GMTBenki Chenduhttp://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspxConsider:[b]Clustering [/b]- Provide failover to another server should the active server running the database fail (not including SAN). This is not a full DR solution (unless you have a mirrored SAN offsite with associated 2nd cluster).http://www.sql-server-performance.com/2002/clustering-intro/[b]Log shipping[/b] - Can be onsite, offsite and the latency is fully configurable and dependent on bandwidthhttp://www.sql-server-performance.com/2002/log-shipping-70/[b]Mirroring [/b]- similar benefits to log shipping but much easier to configure. Requires SQL 2005 and later.http://technet.microsoft.com/en-us/library/cc917680.aspx...also consider replication..Robert MurphyWed, 11 Jan 2012 08:22:30 GMTroasdasdb 89asdasdasd013http://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspxPlease be more specific:1) What's an "acceptable" amount of lost data? i.e. Anything since the last full backup? 2 hours of data? 6 hour? NONE?2) What recovery modes are currently being used in this environment?3) Is this DR-scenario for a transactional-based enviornment or just for historical data (i.e a datawarehouse)?4) What dependencies/gotchas exist?Wed, 11 Jan 2012 08:22:09 GMTMyDoggieJessiehttp://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspxThe DR should be up within 24 hours after the disaster...Wed, 11 Jan 2012 08:15:58 GMTBenki Chenduhttp://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspx[quote]Their motive is just to cover up for some auditing and must be demonstrated only twice in a year..[/quote]It's not a good reason for DR solution.Wed, 11 Jan 2012 08:15:48 GMTDevhttp://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspxThis is a rather large and open question (really more information is needed to more accurately answer your question)...What is the customer's SLA on downtime? What kinds of things need to be backed up? If you just need to back up the DB's (and they are currently in FULL recovery mode) you can set up logshipping to a DR site/server, if you have to backup SQL Agent jobs (which include SSIS jobs) you'll need to script some things out... Can you please be more specific?Wed, 11 Jan 2012 08:09:26 GMTMyDoggieJessiehttp://www.sqlservercentral.com/Forums/Topic1233910-391-1.aspxOne of our customers has requested to setup a Disaster recovery site..Their motive is just to cover up for some auditing and must be demonstrated only twice in a year..Which high availability is the best to use in this scenario?We will have to make sure to use minimal resources.Wed, 11 Jan 2012 05:47:39 GMTBenki Chendu