SQL data recovery

• akm_1k

  Grasshopper

  Points: 15

  More actions

  August 11, 2009 at 3:48 am

  #208377

  can i recover data which is deleted.

• Chand00

  SSCertifiable

  Points: 6466

  More actions

  August 11, 2009 at 4:36 am

  #1037311

  What is your recovery model. What is your backup plan. Without this I think its difficult to answer this. But if you are using full recovery model then you can recover deleted data using point in time recovery. For more info google

  http://www.google.co.in/search?hl=en&q=point+in+time+recovery+in+sql+server+2005&meta=&aq=2&oq=point+in+time+recovery+%5B/url%5D

  [font="Verdana"]Thanks
  Chandra Mohan[/font]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 11, 2009 at 5:23 am

  #1037324

  akm_1k (8/11/2009)

  ---

  can i recover data which is deleted.

  Restore a backup taken before the data was deleted.

  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