sql 2005, mdf restoration, w/out ldf, new box

  • Here is the situation:

    > C drive containing the SQL server 2005 is gone

    > D drive for data is available

    > E drive for logs is GONE

    > no backup of mdf nor the ldf file

    current dondition:

    > a new sql needs to be rebuilt

    > the MDF files need to be restored

    All the attach various commands are not the options because the DBs where shutdown ungracefully.

    So, here is the Q.

    How, to restore an MDF file on the new sql server without the original ldf file.



    I don't think there is such a command as DBCC REBUILD_LOG in 2005...just to make sure we are on the same page.


    John Esraelo

  • use sp_attach_single_file_db to attach only the mdf file to the database server so that a new ldf file is created once the mdf is attached.

    Sugeshkumar Rajendran
    SQL Server MVP

  • Check this link and see the workaround 2 Step 2 http://sql-articles.com/index.php?page=articles/HA/suspectdb.htm

    [font="Verdana"]- Deepak[/font]

  • server A = production

    server B = test/development environment

    server A was a VM and it was destroyed, therefore the SQL engine was gone.

    The databases were on:

    >>> drive XXX for data

    >>> drive YYY for logs

    The two above drives are NAS

    YYY got destroyed too... go figure...

    Therefore the only thing left to do is to figure out if the MDF files can be restored in the test / development environment.

    make sense?


    John Esraelo

  • Current Condition:

    > The MDF files need to be restored

    Restore and Recover your Corrupted SQL server MDF file with all original SQL server database and complete objects like: table, triggers, views and primary key etc. With help of SQL recovery[/url] tool which is professional tool for SQL server recovery. for more info then read this article: http://www.amazines.com/article_detail.cfm/5591869?articleid=5591869

    Thanks & Regards

    Rose Marry Marlo

  • Please note: 5 year old thread.

    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 6 posts - 1 through 5 (of 5 total)

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