How to get datafiles back in sql server 2005

  • Hi All,

    Data files are deleted, Please tell different ways to get back data file in sql server 2005.

  • You deleted the database or detached the database and then deleted the files??

  • Restore from backup. That's pretty much the only real option you have.

    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
  • You can also try for any third party data recovery tool.....

  • Based on three questions in just a few minutes, are you in an interview?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Grant Fritchey (8/31/2010)


    Based on three questions in just a few minutes, are you in an interview?

    If so, with what company?

    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