Wednesday, March 7, 2012

Replication Monitor error

Hi, There was trans-Rep setup on a server which was swap out with an new server. The database were backup and then restored. Replicaito was not working. I disable replication and then set the server up for a distribution. With out setting up any publi
shers there is a error on the replication monitor. I can't find where this error is. I did not set anything up yet. Is there a table I can check?
run this proc sp_MSload_replication_status
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
> Hi, There was trans-Rep setup on a server which was swap out with an new
server. The database were backup and then restored. Replicaito was not
working. I disable replication and then set the server up for a
distribution. With out setting up any publishers there is a error on the
replication monitor. I can't find where this error is. I did not set
anything up yet. Is there a table I can check?
|||I cant find this stored procedure. Is this somthing that comes with SQL?
-- Hilary Cotter wrote: --
run this proc sp_MSload_replication_status
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
> Hi, There was trans-Rep setup on a server which was swap out with an new
server. The database were backup and then restored. Replicaito was not
working. I disable replication and then set the server up for a
distribution. With out setting up any publishers there is a error on the
replication monitor. I can't find where this error is. I did not set
anything up yet. Is there a table I can check?
|||yes, it should be in the master db.
what version of SQL Server r u running.
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:374639C1-95A1-48E9-90AC-CCA6C44F8D07@.microsoft.com...
> I cant find this stored procedure. Is this somthing that comes with SQL?
> -- Hilary Cotter wrote: --
> run this proc sp_MSload_replication_status
>
> "Russ" <anonymous@.discussions.microsoft.com> wrote in message
> news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
an new
> server. The database were backup and then restored. Replicaito was
not
> working. I disable replication and then set the server up for a
> distribution. With out setting up any publishers there is a error on
the
> replication monitor. I can't find where this error is. I did not
set
> anything up yet. Is there a table I can check?
>
>

No comments:

Post a Comment