Replication Error

Hi ,
I have set up some push replication i.e i subscriber and multipler publisher
and i found that in one country the replication failed
it says "subscription is marked inactive and must be re-initialized"
how do i check the error ? and how i can resolved this error ?
tks & rdgsHi
http://groups.google.ch/groups?hl=en&lr=&threadm=108401c36123%24814cf5c0%24a001280a%40phx.gbl&rnum=1&prev=/groups%3Fq%3Dsubscription%2Bmarked%2Binactive%26hl%3Den%26lr%3D%26selm%3D108401c36123%2524814cf5c0%2524a001280a%2540phx.gbl%26rnum%3D1
Regards
Mike
"maxzsim" wrote:
> Hi ,
> I have set up some push replication i.e i subscriber and multipler publisher
> and i found that in one country the replication failed
> it says "subscription is marked inactive and must be re-initialized"
> how do i check the error ? and how i can resolved this error ?
> tks & rdgs|||Hi Mike,
the link that you provided is really useful
tks & rdgs
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> http://groups.google.ch/groups?hl=en&lr=&threadm=108401c36123%24814cf5c0%24a001280a%40phx.gbl&rnum=1&prev=/groups%3Fq%3Dsubscription%2Bmarked%2Binactive%26hl%3Den%26lr%3D%26selm%3D108401c36123%2524814cf5c0%2524a001280a%2540phx.gbl%26rnum%3D1
> Regards
> Mike
> "maxzsim" wrote:
> > Hi ,
> >
> > I have set up some push replication i.e i subscriber and multipler publisher
> > and i found that in one country the replication failed
> > it says "subscription is marked inactive and must be re-initialized"
> >
> > how do i check the error ? and how i can resolved this error ?
> >
> > tks & rdgs|||Hi after looking at this issue I would refer to this article to determine how
to resolve this issue.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replmon_92ge.asp
"maxzsim" wrote:
> Hi ,
> I have set up some push replication i.e i subscriber and multipler publisher
> and i found that in one country the replication failed
> it says "subscription is marked inactive and must be re-initialized"
> how do i check the error ? and how i can resolved this error ?
> tks & rdgs

Replication Error

Hi ,
I have set up some push replication i.e i subscriber and multipler publisher
and i found that in one country the replication failed
it says "subscription is marked inactive and must be re-initialized"
how do i check the error ? and how i can resolved this error ?
tks & rdgs
Hi
http://groups.google.ch/groups?hl=en...gbl%26rnum%3D1
Regards
Mike
"maxzsim" wrote:

> Hi ,
> I have set up some push replication i.e i subscriber and multipler publisher
> and i found that in one country the replication failed
> it says "subscription is marked inactive and must be re-initialized"
> how do i check the error ? and how i can resolved this error ?
> tks & rdgs
|||Hi Mike,
the link that you provided is really useful
tks & rdgs
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> http://groups.google.ch/groups?hl=en...gbl%26rnum%3D1
> Regards
> Mike
> "maxzsim" wrote:
|||Hi after looking at this issue I would refer to this article to determine how
to resolve this issue.
http://msdn.microsoft.com/library/de...plmon_92ge.asp
"maxzsim" wrote:

> Hi ,
> I have set up some push replication i.e i subscriber and multipler publisher
> and i found that in one country the replication failed
> it says "subscription is marked inactive and must be re-initialized"
> how do i check the error ? and how i can resolved this error ?
> tks & rdgs

Replication Error

Hi ,
I have set up some push replication i.e i subscriber and multipler publisher
and i found that in one country the replication failed
it says "subscription is marked inactive and must be re-initialized"
how do i check the error ? and how i can resolved this error ?
tks & rdgsHi
[url]http://groups.google.ch/groups?hl=en&lr=& threadm=108401c36123%24814cf5c0%24a00128
0
a%40phx.gbl&rnum=1&prev=/ groups%3Fq%3Dsubscription%2Bmarked%2Bina
ctive%26hl%3Den%2
6lr%3D%26selm%3D108401c36123%2524814cf5c
0%2524a001280a%2540phx.gbl%26rnum%3D1[/url
]
Regards
Mike
"maxzsim" wrote:

> Hi ,
> I have set up some push replication i.e i subscriber and multipler publis
her
> and i found that in one country the replication failed
> it says "subscription is marked inactive and must be re-initialized"
> how do i check the error ? and how i can resolved this error ?
> tks & rdgs|||Hi Mike,
the link that you provided is really useful
tks & rdgs
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> [url]http://groups.google.ch/groups?hl=en&lr=&threadm=108401c36123%24814cf5c0%24a0012
80a%40phx.gbl&rnum=1&prev=/ groups%3Fq%3Dsubscription%2Bmarked%2Bina
ctive%26hl%3Den
%26lr%3D%26selm%3D108401c36123%2524814cf
5c0%2524a001280a%2540phx.gbl%26rnum%3D1[/u
rl]
> Regards
> Mike
> "maxzsim" wrote:
>|||Hi after looking at this issue I would refer to this article to determine ho
w
to resolve this issue.
2ge.asp" target="_blank">http://msdn.microsoft.com/library/d...
2ge.asp
"maxzsim" wrote:

> Hi ,
> I have set up some push replication i.e i subscriber and multipler publis
her
> and i found that in one country the replication failed
> it says "subscription is marked inactive and must be re-initialized"
> how do i check the error ? and how i can resolved this error ?
> tks & rdgs

Replication - sp_MSget_subscription_guid impossible

We currently have a pull transactional subscription running from a remote 'PublicationServer' in another country to our local server.

After restarting our fire wall we get the following error message:
"The process could not execute '{call sp_MSget_subscription_guid(16)}' on 'PublicationServer'."

This message is followed by another error message: "Another distribution agent for the subscription(s) is running.", although nothing was changed to the configuration and no SQL processes were started or restarted.

When we restart the distribution job manually it runs as if nothing happened.

Does anyone know what exactly caused the failure, and how to prevent it ?

PhilipQuit restarting your firewall ?

I really don't have a good answer for this question. Sometimes after an unexpected failure, the simplest answer is just to manually restart what won't start automagically.

-PatP

Replication - changing a server

This is very important.

I have merge replication with publisher and distributor on the same server and about 20 Subscribers all over the country.
We are moving to another building, with new equipment, so Publisher will be on different server. How to make this move easily, without recreating new publication and pushing new subscribers and implementing initial snapshot, because it will destroy my network.

Is there any possibility to do something like attach/detach DB (distibution and source DB), do few steps more, and to have all like it was before.
Must be.

Thanks in advance.

If you are going to change the publisher server name, you will need to remove replication from the old server and reconfigure it on the new server.

There is another way which you can try:

1) Stop SQL Server on your publisher machine (Machine 1)
2) Rename the machine to something else
3) Copy all the database data files and log files from the old publisher machine to a second machine (Machine 2)
4) Install your new machine (Machine 3), give the old publisher server's name to this new machine
5) Install SQL Server on Machine 3 (which has the old publisher server's name). Make sure the installation directory is the same as the old machine. Bring SQL Server to the same service pack level.
6) Ensure any NT users and logins, AD settings on the new machine is the same as the old machine.
7) Stop SQL Server on Machine 3. Copy over the database data and log files from Machine 2.
8) Restart SQL Server on Machine 3.

Now you should be ready to sync the subscriptions.