Browse by Tags

Tagged Content List
  • Blog Post: SQL Server Profiler showing 9003 Exception when CDC is configured

    While troubleshooting a customers environment I encountered the following 9003 Exception error message captured in SQL Server Profiler. “The log scan number (42:358:1) passed to log scan in database '<db name>' is not valid. This error may indicate data corruption or that the log file (.ldf) does...
  • Blog Post: Troubleshooting LogReader Timeout executing sp_replcmds

    Chris Skorlinski Microsoft SQL Server Escalation Services SQL Server Transaction LogReader Agent timeout executing sp_replcmds occurs most often when a large transactions has been written to the Published database transaction log, or there are a large number of un-replicated commands.  Either problem...
  • Blog Post: Published Database Transaction Log continues to Grow!

    Chris Skorlinski Microsoft SQL Server Escalation Services A customer recently noticed their Published database transaction log would continue to grow until they backed up the Distribution database.  DBCC OPENTRAN() Oldest distributed LSN     : ( 0 : 0 : 0 ) Oldest non - distributed...
Page 1 of 1 (3 items)