Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: Recreate from Log files

    Does anyone know how to recreate a database from a log file? Here is the situation:

    I had a server go bad. The drive configuration was as follows

    Server OS on separate RAID controller - RAID Level 1
    SQL Data on separate RAID controller - RAID Level 5
    Transaction Logs on Separate Raid Controller - RAID Level 1

    I lost the RAID 5 array and can't get it back and don't have a backup. I need to know if/how I can recreate the database from the log file. The log file has been set to grow and has never been purged so I am hoping that I can recreate the database from scratch. Is this possible?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I don't know....but that has got to be a lesson you wont forget


    Check out Lumigent's Log Explorer...There a free trial download...

    I think it's full blown features for 30 days...

    I would also check out the white papers about database recovery best practices...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    FYI...they got back to me pretty quick...

    Hi Brett,

    The answer to your question is that we would need to find a way to
    restore the database (mdf) or connect to a backup file so that Log
    Explorer could connect to that and the Transaction Log. If there is no
    mdf then there is no way for Log Explorer to attach to the database and
    recover the data from the transaction log.

    Let me know if you have any questions about this.

    Best,

    Eric Herman
    Systems Engineer
    E-mail: eric.herman@lumigent.com
    Direct: 978.206.3631
    Toll Free: 866.586.4436
    www.lumigent.com
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2004
    Posts
    2

    Thanks Brett! I will follow up and post the results.

    Originally posted by Brett Kaiser
    FYI...they got back to me pretty quick...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •