top of page

SQL Replication Mark Transaction as commit

  • Writer: Kunal Ranpura
    Kunal Ranpura
  • Feb 5, 2024
  • 1 min read

--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done, it will let you shrink the log file.

exec sp_repldone @xactid = NULL, @xact_seqno = NULL, @numtrans = 0, @time = 0, @reset = 1;


 
 
 

Recent Posts

See All
SQL Server Profiler Trace

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

 
 
 

Comments


bottom of page