How to free 'Log space available'

Last Post 16 Mar 2004 02:09 AM by RaiV. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
RaiV
New Member
New Member

--
15 Mar 2004 11:31 PM
Hi,

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.
RaiV
New Member
New Member

--
16 Mar 2004 02:09 AM
Hi - this is now sorted out - so no need to reply!!
Found that EM was mis-reporting the log available space. Have since resolved this.
You are not authorized to post a reply.

Acceptable Use Policy