Replication Stopped

Hello! Hope everybody is doing OK.
I have a question. I don't know why replication suddlently stopped. In this
case how can I check what was the real problem.
I started synchronizing and it started but I still don't know what was the
cause.
Thank you in advance
Jennyfer
Marlene,
(btw I replied yesterday to your identical post )
I need a bit more info to try to help out:
What type of replication is being used?
When you right-click on the relevant replication agent what error message do
you get (if any)?
Is this the first synchronization (initialization)?
You might also want to use this link for detailedlogging: http://support.microsoft.com/?id=312292
Regards,
Paul Ibison
|||Sorry, I sent the message twice by mistake.
The replication type is Merge. It's not the first synchronization because it
was working good. I didn't get any errors just the information was not
replicated and this problem never happened again.
Thanks so much
|||Marlene,
is the agent working continuously, or on a schedule? Did the agent stop? How
did you eventually get the data to synchronize - did you stop and start the
agent? If the agent never stopped during the problem, but there was a delay
in the commands being propagated then it might be because there were a lot
of other commands being sent down and with one agent the changes are
serialized. Also, I'd check to see if the changed rows are recorded in
MSmerge_contents and MSmerge_tombstone as it may be that your new data was
added using BULK INSERT without firing the replication triggers.
HTH,
Paul Ibison

Replication porblem

Hi everybody,

i got this error message while i'm trying to execute my replication job.

"error 4813"

Expected the text length in data stream for bulk copy of
text, ntext, or image data."

Does anybody have an idea about it?
thanks

Let me know if the workarounds in the below link do not work for you.

http://www.starquest.com/Supportdocs/techSQDR/SQV00DR0013_BCPError.html

|||It seems to work! Thanks
I wonder if there is a Microsoft's KB article about it, 'cause i didn't find any!!

Replication over satelite connection.

Hi everybody, we are designing an application for ships, and I want to replicate data between the ships and a home office. TCP/IP communication is not possible, but we have a e-mail based system for transferring files.
What is the best solution? Is it possible to have the publisher/subscriber to leave a file, and then let the e-mail system transfer the file and then later the subscriber/publisher can pick up the file and do the merge?
Any ideas?
Thanx, Kjetil
Kjetil,
this is not directly possible in the replication setup. You might want to
use DTS to import the file into a database then in the DTS package. Setup
replication between this staging database and your central system and you
can initiate replication locally.
HTH,
Paul Ibison
|||Thanks, this is what I tried to say to my boss. But how can this be implemented? Should I use merge replication or transactional replication.
In my home office, I will need a 'copy' of the ship database, in the first stage 9 ships.
Is it possible to block the database in the ships for updates while the replication process is running?
Or should I use transactional replication, will I then need a 'proxy database' at each ship and one for each ship in the home office. Is it possible to implement conflict resolution methods that guarantee the same result at all sites always?
The amount of data over the satellite link (64k) is an issue, so it is important to send only the changes.
Do you think I'm on track? Is it possible to implement.
Kjetil
|||Kjso,
as you need inserts updates and deletes to be replicated over the internet,
you are essentially coding what MS developers may well be creating in SQL
2005 :-). This is not straightforward at all (to say the least). You might
want to use triggers on each table which write an audit of changes to your
audit table(s). These audit table changes are then sent over the link to a
central server where they are applied to the central database. In my opinion
this is only going to be feasible at the central server if you have
partitioned data; dealing with conflicts will make this too difficult. Then
sending only the changes required back to the other subscribers is not
simple. You say that you want only changes, but a 'snapshot' would be more
straightforward.
HTH,
Paul Ibison

Replication of SPs

Hello everybody,
Does anybody know why SQl Server replication creates lots of other SPs while
creating real SPs, and all the names are like "sp_MSdel_MyTableNames", that
sp_MSdel_ part is repeated in all of them.
Thanks,
Mathew
These are replication stored procedures which the distribution agent uses to
apply the commands that form the transactions on the subscribers.
The naming convention is used to indicate the article (MyTableNames) which
they are used for, the purpose (upd, del, ins) and ownership (MS).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mathew" <Mathew@.discussions.microsoft.com> wrote in message
news:62E5A659-2AEC-4D09-98D2-9D6369C728FD@.microsoft.com...
> Hello everybody,
> Does anybody know why SQl Server replication creates lots of other SPs
> while
> creating real SPs, and all the names are like "sp_MSdel_MyTableNames",
> that
> sp_MSdel_ part is repeated in all of them.
> Thanks,
> Mathew
|||By default, transactions are applied to the subscriber by using
parameterized stored procedures. So, you will get 3 procs created for each
table that you are publishing (sp_MSins, sp_MSupd, and sp_MSdel). The
sp_MSins procs are for inserts. The sp_MSupd procs are for updates. The
sp_MSdel procs are for deletes.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Mathew" <Mathew@.discussions.microsoft.com> wrote in message
news:62E5A659-2AEC-4D09-98D2-9D6369C728FD@.microsoft.com...
> Hello everybody,
> Does anybody know why SQl Server replication creates lots of other SPs
> while
> creating real SPs, and all the names are like "sp_MSdel_MyTableNames",
> that
> sp_MSdel_ part is repeated in all of them.
> Thanks,
> Mathew

Replication issue

Hi everybody,
I have a 2000 to 2005 snapshot replication that has been working
optimally on a nightly basis for months now. I continue to add
articles and new fields to the publisher and these are brought into
the SQL 2005 64 bit box via a pull subscription. We recently modified
a field from 5 to 6 chars and with everthing I read, I have to drop
the subscription to alter the field on the publisher. I have dropped
the field out of the published fields on that table to no avail. Is
there any way around this? If I make a mistake, can I just restore the
distribution db back to get my replication the way it was?
Any ideas? I need to get this done pretty soon...
Thanks,
KristinaPlease take a look at this article:
http://www.replicationanswers.com/AddColumn.asp
Cheers,
Paul Ibison|||On Jun 23, 1:36 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Please take a look at this article:http://www.replicationanswers.com/AddColumn.asp
> Cheers,
> Paul Ibison
perfect thanks! I had forgotten this, I need to drop and re-add...

Replication issue

Hi everybody,
I have a 2000 to 2005 snapshot replication that has been working
optimally on a nightly basis for months now. I continue to add
articles and new fields to the publisher and these are brought into
the SQL 2005 64 bit box via a pull subscription. We recently modified
a field from 5 to 6 chars and with everthing I read, I have to drop
the subscription to alter the field on the publisher. I have dropped
the field out of the published fields on that table to no avail. Is
there any way around this? If I make a mistake, can I just restore the
distribution db back to get my replication the way it was?
Any ideas? I need to get this done pretty soon...
Thanks,
Kristina
On Jun 23, 1:36 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Please take a look at this article:http://www.replicationanswers.com/AddColumn.asp
> Cheers,
> Paul Ibison
perfect thanks! I had forgotten this, I need to drop and re-add...

Replication issue

Hi everybody,
I have a 2000 to 2005 snapshot replication that has been working
optimally on a nightly basis for months now. I continue to add
articles and new fields to the publisher and these are brought into
the SQL 2005 64 bit box via a pull subscription. We recently modified
a field from 5 to 6 chars and with everthing I read, I have to drop
the subscription to alter the field on the publisher. I have dropped
the field out of the published fields on that table to no avail. Is
there any way around this? If I make a mistake, can I just restore the
distribution db back to get my replication the way it was?
Any ideas? I need to get this done pretty soon...
Thanks,
KristinaPlease take a look at this article:
http://www.replicationanswers.com/AddColumn.asp
Cheers,
Paul Ibison|||On Jun 23, 1:36 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Please take a look at this article:http://www.replicationanswers.com/AddColumn.a
sp
> Cheers,
> Paul Ibison
perfect thanks! I had forgotten this, I need to drop and re-add...

Replication Information

Hi everybody,
I′m a beginner in Replication, and I need to find out information about
Replication. If anybody knows "Replications for Dummies or Beginners", let me
know. Thanks a lot.
Richard_SQL
Um.... I just completed a book on snapshot and transactional replication. I
would recommend it highly.
BOL is actually pretty good. You might want to try to fight through the
wizards they are really pretty intuitive.
You can also download a free sample chapter on how to set up replication on
your server in the link below. This should help you get going.
Other than that post back here when you have problems and someone will help
you.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Richard_SQL" <Richard_SQL@.discussions.microsoft.com> wrote in message
news:AFBE0979-D662-4E63-9016-5517F99C43CC@.microsoft.com...
> Hi everybody,
> Im a beginner in Replication, and I need to find out information about
> Replication. If anybody knows "Replications for Dummies or Beginners", let
> me
> know. Thanks a lot.
> Richard_SQL
|||On 2004-12-06, Hilary Cotter <hilary.cotter@.gmail.com> wrote:
> Um.... I just completed a book on snapshot and transactional replication. I
> would recommend it highly.
>
Do you explain the desing philosophy behind the replication process in your
book?
Mike
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr
|||To the best of my ability I did. I was not content with merely a collection
of snapshots, or a re-write of BOL. Getting answers from Microsoft was
difficult in many cases. I was not interested in making a quick buck, but
rather interested in learning replication in great depth, and writing about
what I had learned.
From my work in this newsgroup I think I have know pretty well the full
spectrum of questions on replication and I attempted to answer them to the
best of my ability.
Download the sample chapter. I think this is representative of the depth I
go to in the entire book.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Mario Splivalo" <majk@.fly.srk.fer.hr> wrote in message
news:slrncrbec7.360.majk@.fly.srk.fer.hr...
> On 2004-12-06, Hilary Cotter <hilary.cotter@.gmail.com> wrote:
> Do you explain the desing philosophy behind the replication process in
> your
> book?
> Mike
>
> --
> "I can do it quick. I can do it cheap. I can do it well. Pick any two."
> Mario Splivalo
> msplival@.jagor.srce.hr

Replication in Standard Edition

Hello,
I hope everybody is doing ok.
I'm trying to set up my first "replication". I have the standard edition
of SQL SERVER 2000. While reading the documentation I am trying to identify
the the objects in the Enterprise Manager that the documentation is refering
to. For example Replication Monitor. I don't see this object in my
Enterprise Manager. I am wondering if this is because of the version that I
have, or maybe there is something else that I have to install?
Thank you very much in advance
Marlene A. Roman
Marlene,
the replication monitor is a utility that will appear in EM directly under
the server registration once you have set up a distributor.
There's no need to reregister and the version you have is fine - it appears
on all editions inc Personal Edition which disallows transactional
replication publishing.
HTH,
Paul Ibison
|||the only time it will not appear on a publisher (AFAIK) is when you have a
remote distributor.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23FVSad8KEHA.892@.TK2MSFTNGP09.phx.gbl...
> Marlene,
> the replication monitor is a utility that will appear in EM directly under
> the server registration once you have set up a distributor.
> There's no need to reregister and the version you have is fine - it
appears
> on all editions inc Personal Edition which disallows transactional
> replication publishing.
> HTH,
> Paul Ibison
>