SQL Server Performance Forum – Threads Archive
Shrink Tran Log Error?The tran log on my test database has grown quite a bit, and I did a tran log backup, but now I want to shrink the tran log because it is taking up so much space on my test server. I tried to do a DBCC SHRINKFILE, but I receive the following message: Cannot shrink log file 2 (filename) because all logical log files are in use. What does this mean? I thought that users can be in the database when you do a DBCC SHRINKFILE? Thanks,
"I thought that users can be in the database when you do a DBCC SHRINKFILE?"
No, more when you have full recovery model. Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
May be still uncommitted transactions are existing in that log file.
Check with DBCC OPENTRAN statement, check SQL server error log for any other information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.