Solved

DR setup for SQL based ERP

Posted on 2014-04-21
5
33 Views
Last Modified: 2015-10-11
we are in the progess of going with DR option for Application server and Data Base running on the sql 2008 R2 . what is the best way to move on this . will it be posible to syn the databsed without any 3rd party tools . I hope we need the 3rd party tool to syn the application ?
0
Comment
Question by:cur
  • 3
5 Comments
 
LVL 16

Accepted Solution

by:
Shaik M. Sajid earned 155 total points
ID: 40012156
the best article

http://sqlservertimes2.com/?p=175

as well as

if u have replicated storage solution... i.e ...  Dell Equallogic, or Netapp  there are so man...

these storages will replicate the data at block levels that means you can keep a data any whre in the world  over internet...

this is the storage level DR replication scenaro...

check about it on net.. .for more information

all the best
0
 
LVL 13

Assisted Solution

by:Koen Van Wielink
Koen Van Wielink earned 155 total points
ID: 40013885
A lot of this will depend on what kind of replication you require. MSSQL offers a number of replication options out of the box, depending on your version. Key questions to answer will be whether the DR site needs to be on automatic failover, whether or not you can afford some data loss, and if so, how often you wish to update your DR site.
Log shipping, mirroring and, if you're using MSSQL 2012, "always on", are probably your 3 options if you don't want to use 3rd party tools.

Log shipping is a periodic backup/restore of the transaction logs to 1 or more secondary servers. It's less heavy on your network load because of the periodic synch, but because it's periodic there's a risk of data loss. But you can keep multiple backups of your database. Failover is manual.

Mirroring uses automatic failover, but can only keep 1 copy (in SQL 2008). Also, if you're using multiple databases, if one fails and the server defaults to the mirror, the other databases might still be running on the original server. Because your mirror is a real time synchronization it requires a very stable, probably rather high bandwidth, connection.

Always on is only available in SQL 2012 and combines mirroring with clusters, allowing automatic failover as well as keeping multiple secondary servers on standby. Availability groups allow you to keep groups of databases together that failover together.

Hope this helps.
0
 

Author Comment

by:cur
ID: 40014054
we have sql 2008 r2 and trying to asnch mirroring to vitual datacentre envin. is it posible to mirror cluster to vm based hosted infrastructure
0
 

Author Comment

by:cur
ID: 40014122
I hope asynchronous mirroring will  not affect the production database  ? and also this will depend on the databe recovery mode : simple,full ..........
0
 

Author Comment

by:cur
ID: 40026750
wha is the best latency can go with the above . procustion database and DR mirred databsed ? i hope banks is using the same way of replication concept ?
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Present Absent from working date rage 11 36
Easy filter aspnet 2 24
(sql serv16)ssis 2016 question/check 1 68
SQL Database Restore 2008 R2 1 7
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question