That is what I tried.

Please see my original email. I already tried all these steps.

for Client

server also SQL same: SQL 2008 SP3

Windows version for server : 2008/2003

going back to my first question

Reporting server 2 - undistributed transactions 9442941 – est time 10 hr 34 min

It clreated the phontom backlog so quickly...in 5 hrs..so how did it...

I got the article list by running below query.

Now I want one (or a set of ) primary keys that replication considers is not replicated everywhere.. is there any...

Thank you.

Syncing is happening not for the first tme after the outage.

The scripts you gave--what is target server/database to execute?

thanks for your help.

Lastly, undistributed transactions are same for both subscribers...

Thank you.

Publisher and distributor are separate servers.

If you really want to gauge the performance of which one(s) is causing the issue(s) stop/disable the Log Reader Agent for a couple of...

thanks. I am going to use 3rd one. thanks again.

Resolved. looks like intermittent.

reran the job and job ran successfully

Yeah server is accessible. Resolved.

I cleared the job history and restarted the jobs. Now jobs are running fine.

Looks like intermittent network connectivity.

Thanks

Thanks.

I modified the file/location and it worked. thanks again

Resolved. sql services started..issue with accountname

thanks all

Resolved, renamed sql instance to match with hostname

and started sql with correct accountname. thanks

We are using spotlight.

I ran sp_who2 and also checked in activity monitor, there are no blkby sessions.

I ran below query. No output.

select * from sys.dm_exec_requests

cross apply sys.dm_exec_sql_text(sql_handle)

cross apply sys.dm_exec_query_plan(plan_handle)

where session_id = 63

Looks...

Is this something I can do in SSMS-databasemail ?

thanks