Saturday, 31 January 2026

SQLDBA- Troubleshoot replication issue.

While encounter the error with replication. We can find which table  name and  which record having an issue  with replication with below commands. 


we need to  run these below commands in distribution database.    


-- run below command in distribution data base 

USE <DB name>

GO

SELECT TOP(10)* FROM MSrepl_errors

ORDER BY TIME DESC

-- Take Xact_Seqno & command _id from above resulut set and pass in below command


SELECT * FROM Msrepl_commands

WHERE xact_seqno = 

AND Command_id =


We need to pass below values from above result set. 

EXEC SP_BROWSEREPLCMDS

@xact_seqno_start = '',

xact_seqno_end = '',

@publisher_database_id= 1,

@article_id=1,

@command_id=1




No comments:

Post a Comment

SQLDBA - Get Space Used by Tables and Indexes in SQL Server

 Get Space Used by Tables and Indexes in SQL Server Databases can consume significant amounts of storage, so it’s important to understand ho...