Hi. We have a DB on a sql server 2005 server that is 600MB data and 242 GB log, but I can't shrink the log, even after doing a backup tran of the log.
The dbcc shrinkfile(logfilename) doesn't give an error, just doesn't work.
This is a production server, so I don't want to set the recovery to simple, unless there is no other way.
The DB options are:
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics
Please advise on any suggestions to free up space. Thanks.