Free Log space query

• glyve

  Grasshopper

  Points: 15

  More actions

  December 17, 2003 at 12:09 pm

  #83108

  refer previous post

  http://www.sqlservercentral.com/forum/post.asp?method=Reply&TOPIC_ID=19300&FORUM_ID=9&CAT_ID=1&Forum_Title=General&Topic_Title=Cursor+in+ExecuteSQL+task+%22drops%22+some+values">

  http://www.sqlservercentral.com/forum/post.asp?method=Reply&TOPIC_ID=19300&FORUM_ID=9&CAT_ID=1&Forum_Title=General&Topic_Title=Cursor+in+ExecuteSQL+task+%22drops%22+some+values

  How does one go about getting free log space using a Query?

• mdaniel

  SSCarpal Tunnel

  Points: 4616

  More actions

  December 17, 2003 at 1:37 pm

  #486815

  With DBCC SqlPerf(LogSpace) you can get the percentage free and the total log size.

  Use the following script to get free and used log space.

  create table #logspace

  ( dbname varchar(50),

  logsize numeric(14,6),

  perc_used numeric(14,6),

  status int )

  insert into #logspace

  exec ('dbcc sqlperf(logspace)')

  select 'Database' = dbname,

  'Log Space Used (MB)' = (logsize * perc_used / 100),

  'Log Space Free (MB)' = logsize - (logsize * perc_used / 100),

  'Log Space Total (MB)' = logsize

  from #logspace

  drop table #logspace

  Edited by - mdaniel on 12/17/2003 1:38:31 PM