Virtual Log file Information

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  September 13, 2005 at 9:52 pm

  #110192

  Hi,

   

  Pls help me in getting information about virtual log file.

   

  how can i get the information about the virtual logfile that what database is using what logfile (name),startoffset(means from which point it started to write in VLOGFILE),,status(ACTIVE or DEACTIVE),

  Sequence(VLOGFILE NUMBER) , SIZE(The size of this portion of the log in MBs.)

  Any help will be appriciated.

  from

  Killer

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  September 15, 2005 at 10:51 am

  #590237

  Try DBCC LOGINFO('your_database_name').

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."