Tuesday, 18 February 2014

Replication Transaction is pening in DBCC Opentran () command

1) Select * from master..sysprocesses where status <> 'Sleeping' orderby login_time,last_batch desc


Question

On running DBCC Opentran()

 I am getting below:

Transaction information for database 'DATABASE Name'.

Replicated Transaction Information:
Oldest distributed LSN : (34595:32751:24)
Oldest non-distributed LSN : (0:0:0)
DBCC execution completed. If DBCC printed error messages, contact your system administrat

Solution
-------------------------

Execute SP_ReplicationDbOption XXXXX,Publish,true,1
Go
Execute sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1
GO
DBCC ShrinkFile(XXXX_Log,0)
GO
Execute SP_ReplicationDbOption XXXXX,Publish,false,1
GO

No comments:

Post a Comment