Post reply

Database crashed

  • April 5, 2009 at 2:05 am

    #384288

    My database is crashed, when i searching i can see morethan one mdf file how can i know which one was the latest/orginal

  • April 5, 2009 at 2:37 am

    #972150

    Got a backup? If so, restore that.

    Are all the mdf files the same name? What's the modified date on the files? Do you have the ldf file as well?

    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

  • April 5, 2009 at 8:53 pm

    #972253

    There should be only one MDF file for each database. You can try to attach them and get some info from each one as you do.

    If you have multiple ones with the same name, get the one with the latest filestamp.

    Note also that the name of the MDF has nothing to do with the name of the database. It's a default to name them the same, but it can be changed. I can have the AdventureWorks database with physical files test.mdf and test.ldf

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

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