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 |
|
traigo
Starting Member
4 Posts |
 Posted - 2007-09-03 : 15:36:46
|
| I've been through just about everything I can find in google to figure out how to do this. I need to replicate a database to a backup server. The replication is one way. Both are standard editions so I can't use log shipping. It is not my database, but rather one for a proprietary application. I can't change any of the tables without it flipping out. Some of their tables have > 255 columns. Is there any way I can replicate? |
|
|
traigo
Starting Member
4 Posts |
Posted - 2007-09-03 : 16:00:23
|
| The database changes quite a lot during the day and is ~6gb. Using full logging method, the log grows by an average of 50mb per day. The database size doesn't grow but a gb/year, but the data within it is changed quite often. I don't think snapshot would work very well. |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-03 : 19:41:06
|
| Why not use transactional replication?------------------------Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 21:56:33
|
| By the way, you can buils your own log shipping process. Or get it from sql resource kit. |
|
|
|
|
|
|
Replication solution needed