Posted on 2006-06-15
My SQL DB log file is getting too big.
When i ran DBCC SHRINKFILE(My_Log,100), it says "Cannot shrink log file 2 (my_Log) because all logical log files are in use".
When i change targent size to 200, it says "Cannot shrink file '2' in database 'DBName' to 25600 pages as it only contains 14048 pages.
When this DBCC SHRINKFILE actually works? I am cofusedand... and how we gonna know that it's shrinking the log file.
I think it is supposed to lower the log file size, right? My log files are in GB and still in GB.