Link to home
Start Free TrialLog in
Avatar of cur
curFlag for Sri Lanka

asked on

DR setup for SQL based ERP

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 ?
ASKER CERTIFIED SOLUTION
Avatar of Sajid Shaik M
Sajid Shaik M
Flag of Saudi Arabia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cur

ASKER

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
Avatar of cur

ASKER

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

ASKER

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 ?