Post reply

Offline info

  • August 11, 2011 at 8:26 am

    #255645

    When a database(Test region) kept in offline mode..How to get the log info?

    Can anyone suggest me.....Thanks...

  • August 11, 2011 at 8:29 am

    #1367323

    What log info? SQL Agent Log, Error Log, Log on .....etc??????

    :cool:

    "There are no problems! Only solutions that have yet to be discovered!"

  • August 11, 2011 at 8:31 am

    #1367326

    bopeavy (8/11/2011)

    What log info? SQL Agent Log, Error Log, Log on .....etc??????

    I use dbcc loginfo('database')

    to see the status...

    i want to see vlf status....

    Thanks..

  • August 11, 2011 at 8:37 am

    #1367332

    Beginner2008(8/11/2011)

    I use dbcc loginfo('database')

    to see the status...

    i want to see vlf status....

    You are not making any since. The dbcc loginfo command returns the status of the virtual log files within the physical transactional log.

    http://sqlserverpedia.com/wiki/Maintenance_DBCC_Commands

    :cool:

    "There are no problems! Only solutions that have yet to be discovered!"

  • August 11, 2011 at 8:48 am

    #1367349

    You'd need to bring the DB online to get information on the active portions of the transaction log.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply