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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-05-04 : 08:27:13
|
| guys,I have database with in the intranet which I have to sync up in the night with the prod database. I have been trying to use replicatiion - subscriber and publisher model but it would slow down the subscriber drastically.Is it because replication agent is polling constantly ?Is there any better way to accomplish this goal using replication, can you guys point to any resources.any comments/suggestions are appreciated.Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-04 : 08:47:11
|
| well if you have to sync it only once per day maybe snapshot replication would be best suited for your needs._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2007-05-04 : 09:25:16
|
| Is there any specific way to setup snapshot replication.can insight and resources would helpThanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-04 : 09:32:38
|
| You can find it in books online. |
|
|
|
|
|
|
Replication question