I am not the usual 6.5 DBA so am a bit stuck on the following....
I am trying to free log space - data size: 4GB, space available 2.2 GB, log size 550MB space available 0 MB.
I have allocated more space to the database device, then expanded the log (which is on its own device, separate from the db) but the 'log space available' remains at 0 MB. I then tried truncating the log, then backing up the database - no change, backing up the log on its down (DUMP TRANSACTION) - still on 0 MB. I then checked DBCC OPENTRAN on this database & there are no open transactions.
Any help appreciated.