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 |
|
jhnegrao
Yak Posting Veteran
81 Posts |
 Posted - 2009-03-18 : 17:12:36
|
| Hi, All!I have to make a copy of all databases of an SQL Server because I can't keep Backup and Data stored in the same building. As We don't have money to build another Datacenter, so I can't put my Backup solution in another place.Because of that, I was thinking to replicate my data to my site, but the problem is the WAN between these two sites is a dual 2Mbps. I have no deadline to replicate the data, but I want a solution with a few amount of risks.I thought:- Transaction Replication- Log Shipping- MirroringAnybody knows another possibility that brings me more reliability, less replication of data problems, less possibility of have to replicate all the data again.Thanks for adviceBest Regards |
|
|
SCHEMA
Posting Yak Master
192 Posts |
Posted - 2009-03-18 : 17:18:11
|
| Then you can backup to tapes .This is the cheapest solution according to your questions.Everything needs to hit primary server . |
 |
|
|
|
|
|
Replicate All Databases to another server