May 29, 2015 at 1:59 pm
Hi
select * from distribution..MSdistribution_history order by time desc
152015-04-26 21:03:32.3402015-05-28 20:09:10.2072761538Query timeout expired0x0010EC6E0000351C0007000000000000018074962114753121561994310241.62490469034904788693792351110x0000000000D16B6E
started then after I am getting msg the process couldn't connect to subscriber
Any help?
May 29, 2015 at 2:40 pm
Is your subscriber online? Or are there any processes blocking your distributor sessions?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 29, 2015 at 3:24 pm
It is online but just restarted the sql server. I started the reinitializing the subscriptions using the snapshot but how to find how much time it will take to complete that snapshot?
May 29, 2015 at 3:50 pm
That depends on many factors. Not sure "how long" but you can find out how large the snapshot for the tables will be by running something like:
SELECT pubname ,
SUM([Total(MB)] ) / 1024 'Total(GB)'
FROM ( SELECT DISTINCT
a .pubid ,
a .name AS PubName ,
OBJECT_NAME(i .id) AS TableName ,
MAX(i .[rows]) AS 'Rows' ,
CONVERT(dec (10, 3), SUM(i .reserved * 8.000 / 1024 )) AS 'Total(MB)'
FROM dbo. syspublications a WITH ( NOLOCK )
INNER JOIN dbo.sysarticles b WITH ( NOLOCK ) ON a .pubid = b.pubid
INNER JOIN dbo.sysobjects o WITH ( NOLOCK ) ON b.dest_table = o.name
INNER JOIN dbo.sysindexes i WITH ( NOLOCK ) ON o.id = i. id
WHERE i. name NOT LIKE '_WA_Sys_%'
AND i. indid IN ( 0, 1)
AND i.rowcnt > 0
AND o. type = 'U'
GROUP BY a .pubid ,
a .name ,
OBJECT_NAME(i .id) ,
i .indid
) a
GROUP BY a.PubName
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply