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 |
|
JEBanasik
Starting Member
2 Posts |
 Posted - 2008-05-12 : 18:56:25
|
| We have a user Training database that we would like to keep updated from our Production database. Users would make different modifications to the Training and Production databases. It is the user updates on the secondary that bother me and I have not seen anything that indicates Log Shipping would fail if new random records are added to both the secondary and primary.Would Log Shipping be appropriate for this nightly update of Training from Production?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-12 : 19:33:19
|
| Didn't get your question clearly? You can't update anything in secondary if you are doing log-shipping but you can read-only. You need to have replication in this scenerio. Tell what is the exact requirement? |
 |
|
|
JEBanasik
Starting Member
2 Posts |
Posted - 2008-05-12 : 21:57:02
|
| You confirmed what I suspected. The only changes to the secondary must come from Log Shipping. We were trying to avoid full backup (from Production) and restore (to Training) each night.Thanks |
|
|
|
|
|
|
Log Shipping for Training Database