Recover SQL server 2008 database

  • The DB had two files a .mdf of 68MB and a .ndf of 12GB

  • Was the DB structured with just one filegroup or two?

    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
  • The database has one filegroup.

    Regards

  • Can I get an online service where I can upload the files on rapidshare.com and get them analysed and recovered?

  • If you're asking for volunteers to analyse and recover, the chance is virtually 0. There are no more than a handful of people in the world capable of rebuilding a SQL database like this, most work for Microsoft. It's a hectically difficult and time consuming job.

    There are SQL data recovery tools, I don't have much confidence in any of them. I've seen two used and neither extracted useful information. If you do try, make sure you get a trial and don't pay until you're sure it's going to help. They're not online, they're download, install and pay tools.

    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 - 31 through 35 (of 35 total)

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