Post reply

fetch data from ldf files

  • February 6, 2007 at 11:06 pm

    #194227

    hello everyone ,

    i am USING sqlserver 2000, i get the .mdf AND .ldf files,now i want TO write the queries that purge my data FROM the ldf files.

    IS that possible my query FETCH the data FROM ldf files NOT the actual database??

    kindly reply me its very important AND urgent FOR me.

    Thanx in Advance..

     

  • February 7, 2007 at 12:35 am

    #688208

    the ldf is the transaction log. It's the record of what modifications have been made and isn't intended to be read.

    What info are you trying to get? Why do you want to read the tran 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

  • February 8, 2007 at 2:48 am

    #688488

    I never fail to be surprised by some of the posts.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 3 posts - 1 through 3 (of 3 total)

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