New answers tagged dbcc
My work around for the Replication that is blocking shrinking log file is: Set DB Recovery Model to Simple Take DB offline Create backup of log file (just in case) Delete log file Bring DB online In my case it worked. After bringing DB online log was created automatically and it's size was 512kb instead of 70GB. But this is only a workaround. The root ...
I would try that: drop all indexes rebuild the clustered index run dbcc create index run dbcc I would also check the hardware (disk) for inconsistencies.
Top 50 recent answers are included