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 |
|
Bobba Buoy
Starting Member
36 Posts |
 Posted - 2003-07-17 : 09:49:32
|
| I have a merge publication set up on our system. I am using my machine as the publisher/distributor with an adjacent machine as the subscriber. I think I set it up correctly but it didn't generate an initial snapshot and I don't know why or how to do this. Any ideas?I am doing all of this from the Publisher. What do I need to do on the subscriber end? I am using this replication as a redundant database so that I can disconnect and take it to a non-connected location. After a 'job' is done I will want to merge the data back. Does this have to be done manually? Do I have to create a push subscription from the subscriber? Or a pull subscription from the publisher? Or do these things not apply with merge publications? Thanks for your help!!! |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2003-07-17 : 22:07:46
|
| Hi,First: Cannot you think of a cluster for High Availibility, instead Replication?Second: You can choose puul or push subscription at your will. But do not forget to configure the publisher/publication to allow updates (so you can keep it up to date in a failure.)Third: Have you Asked SQL Server to generate the Initial Snapshot, by specifyin it should initialize the data in the subscriber?Sérgio Monteiro |
 |
|
|
Bobba Buoy
Starting Member
36 Posts |
Posted - 2003-07-18 : 07:22:22
|
| Thanks for your help. What do you mean by a cluster for High Availability? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-18 : 12:41:03
|
| Clustering is just one part of a high availability solution. I am not sure why Sergio brought it up since you didn't mention that you were using replication as your high availability solution. Sergio, I believe, was just pointing out that replication is not a high availability solution, but I doubt that's what you are using it for anyway.Tara |
|
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2003-07-26 : 19:44:29
|
Bobba and Tara, I misunderstood the point (English is not may strongest point ). I did understand that you Bobba was using the replication as a redundant db, to provide high availabity. Sorry. Forget this point in my previous answer.Sérgio Monteiro |
|
|
|
|
|
|
Initial Snapshot