MSSQL 2005 Enterprise warm standby for DR site
Posted on 2010-08-25
In our company, we have a SQL 2005 enterprise 64-bit database in primary site and we are planning a DR
site. I had a lot of research in Internet but still cannot make the decision between transactional replication
or log shipping.
what we need is a warm standby in sync with primary ( 30 min behind primary is our SLA) and be able to bring database
up and running in case of a failure.
here are the options as far as I know :
• Log shipping
I am kind of new to MS SQL ; wanted to get advise from an expert who've done this in a production enviornment.
Really appreciate your help.