Hi.
I have taken a database backup from production and restored it in Dev server.The database size is of 160 GB.So i planned to shrink database file.i used the following statement
DBCC ShrinkFile('ChangeDM',1)
While executing the statement,I am getting the error "Cannot shrink log file 4 (ChangeDM_Log1) because all logical log files are in use".
I have used the Open tran Statement to view the open transaction in Database.
I get the following Results
Replicated Transaction Information:
Oldest distributed LSN : (2120809:18651:1)
Oldest non-distributed LSN : (2120809:18920:2)
Replication is configured in Production only and not in my Development server.
Please Help me to resolve the issue