I am not able to shrink the Log of my database.
While using the dbcc shrinkfile or dbcc shrinkdatabase command, I get the following Error
Cannot shrink log file 2 (LOG FILE) because all logical log files are in use.
Also in the results Grid I get the folowwing.
DbID FileID CurrentSize MinimumSize UsedPages EstimatedPages 7 2 3111832 2560 3111832 2560
Hi check out this post.This explains why DBCC shrinkfile fails and what do you need to do for it
What is the recovery model you have ?
1. Backup the transaction log.
2. Shrink it.
3 Create a maintenanace plan to do the backup regularly.
We walk in the dark places no others will enterWe stand on the bridge and no one may pass