Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2006-03-17 : 18:00:46
|
| SQL2005Does anyone have any experience/ideas about replicating a handfull of OLTP databases (80gig) and a OLAP database (20gig) to a disaster recovery site on a different network several miles away?Can I keep my databases in simple mode and use transactional replication?What kind of communications line can I get in the UK to send the data down without a hefty phone bill?Does introducing publisher replication on my live database server effect it's performance significantly? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-03-19 : 10:30:18
|
| >> Can I keep my databases in simple mode and use transactional replication?No.Depends on what sort of dr site you need. i.e. how quickly you need to bring it on-line and how much data you can afford to lose.Consider full backups and differentials - that will be simplest but might not be good enough for you.I wouldn't use replication for a dr site but often log shipping is a good option (not the ms version - code it yourself so you have control).If you are talking about phone lines for comms then I wouldn't consider an online connection. Maybe put the logs on an ftp site and download them to the dr site.Look at www.nigelrivett.netEverything to do log shipping and ftp from sql server is there.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
disaster recovery