2012年3月19日星期一

Disater Recovery Solution using SQL

Hello,
For my DR soluion I am using an XP1024(Hitachi) array to sync data from
production site to DR site. My SQL servers take up a lot of bandwidth during
high business times with other applications. What is another way I can sync
the data from site A to site B? Is replication the answer?
Replication isn't recommended as a disaster recovery solution, all though it
can be used as such.
The main reasons are
1) not automatic failover
2) you have to reconfigure your apps to point to the new server
3) no system objects are replicated
4) not complete support for changing schemas - i.e. you can't change a pk
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
news:98B3CFB8-27DF-40A3-B21C-B48C7BE4EF26@.microsoft.com...
> Hello,
> For my DR soluion I am using an XP1024(Hitachi) array to sync data from
> production site to DR site. My SQL servers take up a lot of bandwidth
during
> high business times with other applications. What is another way I can
sync
> the data from site A to site B? Is replication the answer?
>

没有评论:

发表评论