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 |
|
betesh
Starting Member
34 Posts |
 Posted - 2008-06-17 : 06:29:06
|
| I went to View Synchronization status and see that the sychronization has been running for two hours already. Is that normal? I thought it would just find the one change I made and update that one change? Thanks in advance! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-17 : 07:14:09
|
| Depends on the size of the table and whether it is locked. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-17 : 09:33:57
|
| Because you choose to run continuously . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-18 : 22:11:49
|
| >> sychronization has been running for two hours already. For initial snapshot or else? |
|
|
|
betesh
Starting Member
34 Posts |
Posted - 2008-06-18 : 23:43:15
|
| I'm new to replication so I am not sure. I just know that when I went to the View Sync status it was still running. I ended up cancelling it since it was just a test.How can I schedule for sync to only happen once a day? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-19 : 08:13:01
|
| You can set a schedule. |
|
|
|
betesh
Starting Member
34 Posts |
Posted - 2008-06-19 : 08:27:52
|
| Yes, that is what I am getting at. I would like to set a schedule. But HOW? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-19 : 08:31:10
|
| You set the schedule on the distibution agent when you set up a subscription to the publication. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-19 : 23:05:40
|
| But scheduled sync will not be faster. |
|
|
|
|
|
|
Synchronization running for 2 hours already