sql server replication: Manual Replication? -- sql server replication

Manual Replication?

Ero Edgar
10/30/2003 10:23:36 AM

sql server replication:

Hi again:

1. If the replication fails it send me an email of the
error with an alert, that is ok...

2. i have to have to be a SA or a SA equivalent to see on
the monitor the replica fail on the enterprise manager.

3. On the enterprise manager i have to go to publisher
fail and select the fail and Syncrohnize now...

there is 2 facts: the user be SA and the solution of
the fail replica is manual on the enterprise manager.

My questions are:
how can i detect if the replica fail or some publisher?
is possible to make a syncronize of the replica from a
command prompt?

Thanks AGAIN!!!!!!!!!!!

Manual Replication?

Ray D
10/30/2003 9:03:20 PM

To start synchronization manually you can either use SQL-
DMO or
command prompt utility
OSQL.EXE -S <your_server> -r -n -d <database> -U <user> -P
<password> -Q "sp_start_job <the name of the job that
starts replication agent>"
[quoted text, click to view]

Manual Replication?

Ero Edgra
10/31/2003 1:11:23 PM

Thanks for the info...but if i have define on the database
a publisher called "Publicacion Contal" how can i
syncronize that?? is it possible?

Manual Replication?

Ray D
11/2/2003 2:48:26 AM

Do you have push subcriptions?
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.