Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Query Timeout Expired Error

  
   Database Help (Home) -> Replication RSS
Next:  Accent problem  
Author Message
venkat reddy

External


Since: Jan 24, 2010
Posts: 1



(Msg. 1) Posted: Sun Jan 24, 2010 4:31 am
Post subject: Query Timeout Expired Error
Archived from groups: microsoft>public>sqlserver>replication (more info?)
i have configured transactional replication. Publisher and distributor on
same server ,when data is transmitted from distrubutor to subscriber the
query timeout error was occured and distribution agent is retrying to
transfer cmds.
Please suggest me on this error.


Thanks
venkat

 >> Stay informed about: Query Timeout Expired Error 
Back to top
Login to vote
Paul Ibison

External


Since: Nov 21, 2009
Posts: 4



(Msg. 2) Posted: Sun Jan 24, 2010 2:26 pm
Post subject: Re: Query Timeout Expired Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I'd take a look at the subscriber database and see if there is any blocking
(sp_who2).
HTH,
Paul Ibison

 >> Stay informed about: Query Timeout Expired Error 
Back to top
Login to vote
NMahmoud

External


Since: Jan 30, 2010
Posts: 1



(Msg. 3) Posted: Sat Jan 30, 2010 10:51 am
Post subject: Re: Query Timeout Expired Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
the account used for the "Subscriber Connection" should be a "dbo" in the
destination database.


"venkat reddy" wrote in message

> i have configured transactional replication. Publisher and distributor on
> same server ,when data is transmitted from distrubutor to subscriber the
> query timeout error was occured and distribution agent is retrying to
> transfer cmds.
> Please suggest me on this error.
>
>
> Thanks
> venkat
 >> Stay informed about: Query Timeout Expired Error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Timeout error with transactional replication - I have a 100gb db on win 2k sp3/sql server 2k sp3. I am trying to start trans replication on a newly restored backup that is across the wan with a push subscriber. here is the problem. When it is trying to connect I receive a "Timeout expired (Sour...

SQL2000 - Merge Replication - Timeout error - Hi NG We have merge replication running successfully between 2 SQL2000 boxes via VPN. The agent profile is "Slow Link". On Tuesday, the replication stopped working. Verbose logging indicated a timeout issue. I created a new profile with...

Is there any way to know a subscription is nearly expired? - Hi all, Here is my case: I'm using SQL 2000 and there is a publisher (Windows Server) and several subscribers (XP on PC or notebook). All 3 types of replication (transactional, snapshot, merge) are used in several replications. Some PCs and..

Expired subscription clean up - Failed - Hi, I have a merge replicate setup and is working fine. Suddenly since last 4-5 days my "Expired subscription clean up" stored procedure started failing. The error message in the job history is Unable to connect to SQL Server '(local)'. Th...

Transactional Replication Subscriber went missing after Ti.. - I have Transactional Replication from one of the databases out to a reporting environment (both SQL 2000 SP4). I have a transactional database which is the publisher (where I have the distribution database) and replicating out to a reporting environment...
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]