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 |
|
perryh73
Starting Member
1 Post |
 Posted - 2004-06-11 : 06:46:31
|
| Hi,Ny names Perry, Im new here and new to the guts of SQL 200 Server, Ive used SQL server to create a new db and transfer from access>sql and setup dsns for access etc but now Ive had to grow up and do proper work!I have 4 servers, 1 is the master publisher with three subscribers.I have published the db I want to repl with Transactional updating and possibly incorrectly I have included all tables/sp/id parts.The repl started yesterday and now I look and see the db on the master is 23.5mb which is what it should be just now and the remote one is 55mb! Anyone offer an explanation or where and how I can start looking to see whats going on.Any suggestions much appreciated.Perry/Wheee! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-11 : 12:59:56
|
| Replication is not an easy thing to tackle and should be done by someone with replication experience. You need to take a step backward and redo what you have setup. Delete replication and then set it up slowly only grabbing the objects that need to be replicated. To see what is going on, take a look at the replication monitor in Enterprise Manager.Tara |
 |
|
|
|
|
|
Replicating a db; original one smaller than remote