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 |
|
dolphin123
Yak Posting Veteran
84 Posts |
 Posted - 2012-07-30 : 15:49:57
|
| Hi,I am working on building a DR environment.Our Production environment is hosted externally and has a 10 MBPS link over VPN between our office network and the hosted environment.The database only get written last 4 days of the month. The best solutions we have - someone goes to the hosted platform, copy all the backups, bring it in-house and restre it manually.With this bottleneck of 10 MBPS network in the picture, is there anyway to keep the DR environment's database in sync more efficiently? Thanks a lot in advance.- D |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dolphin123
Yak Posting Veteran
84 Posts |
Posted - 2012-07-30 : 16:24:42
|
| Thanks Tara. The total size of all the databases are around 5 TB. But the changes are probably like 300 GB, I think. My manager recommended log shipping as well.The developers have setup this backup plan for the Production environment - One weekly full backup (every Saturday), rest of the days a transactional backup is taken). Will this interfere with my plan to do log shipping. How do I go about learning this. Is the chapter on "Log Shipping" in MS book for exam 70-443 enough. or should it be more? Please let me know if there are any pit falls I need to watch out for?Thanks in advance- D |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dolphin123
Yak Posting Veteran
84 Posts |
Posted - 2012-07-30 : 16:31:44
|
| No. I am going to read through the book on this, test it in the lab environment and set this up my self. :)Thanks for all the infor, Tara. Much appreciated.- D |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Best Database Sync strategy