asked on

SQL Replication

I have SQL Replication going from one server to another server to update two databases

Im on the replication publisher....where its pushing out the data..
I then right click to Agent History.......
I see start time 20060413 and time of last action is 20060420 Duration 7d

I was wondering why the start time would not be todays date....

I get a lot of Timeout expired too..............and subscription have been marked for inactive and must be reinitialized.

How do i double check its running.................without having to do count of records in database1 to replication database....

EugeneZ

what is the agent name?

TRACEYMARY

ASKER

Agent name bear with me never looked at replication before...

When click on Publishers..
i have two name is SERVERNAME:DATABASEA
i have two name is SERVERNAME:DATABASEB

Under Agents
Snapshot Agent....Stopped

Log Reader
Running

?

EugeneZ

where did you check 'agent history'
at
Snapshot Agent?

TRACEYMARY

ASKER

I in replcation Monitor, server, then to one under there,,that gives me the two replication to database a and b then i right click then do agent history

ASKER CERTIFIED SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TRACEYMARY

ASKER

ASRCFHSQL1\SQL1-DeltekCP-ASRCFHSQL2\SQL2-1

SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TRACEYMARY

ASKER

In enterprise manager i click on server
then on Replication Monitor
Publishers
ASRCH
Under here i have blue book symbol DELTEKCP All replicable tables
This brings up
Snapshot
Log Reader
ASRC SQL2 DeltekCP Push
ASRC SQL2 Govwin Push

So i right click on ASRC SQL2 Deltek Cp and do Agent History

Inside of here i see the log

#Actions Last Action Start Time Time of last action Duration
2 2 transactions with commands were delivered 20060413 20060420 7d etc
3 time out expired 20060412 20060413 17:45
lots of time outs.
3 the process was successfully stopped

These are all on one server...................

Results are going to subscription on Another Server

I believe the replication is Snapshot ....................and using distrubtion database

TRACEYMARY

ASKER

Thanks....i found out its not running.....and just go processes in my logs....and the records counts do not match so i am going to do another snapshot.
I assume doing another snapshot will fix this.

EugeneZ

snapshot?
why not transactional replication?
instead snapshot - use log shiping - or review biz requirments for replication topology
e.g. :
If you need keep fresh data on subscriber- then
trans replication with pull subscriber would be your solution...

TRACEYMARY

ASKER

Let me check what one it is using......if i need help on that i post another thread ...to change snapshot to transactional.
First time ever looking at replication so i have a look on monday

Thanks