1

Is it possible to restore the deleted database in SQL Server 2005?

The accident operation by someone: right click database > deleted. How to restore it?

Andriy M
  • 76,112
  • 17
  • 94
  • 154
Plipus Tel
  • 666
  • 3
  • 13
  • 23
  • Do you have a backup? – lc. Dec 09 '13 at 06:25
  • Unfortunately no. I just have the latest backup at Thursday. The Friday the database has deleted, and all my updated date at Friday gone. Any idea? help – Plipus Tel Dec 09 '13 at 06:27
  • 1
    lol,:) if he had backup he wouldn't have posted this question i guess [read this](http://stackoverflow.com/questions/14675969/recover-database-with-no-backups) – vhadalgi Dec 09 '13 at 06:31
  • 1
    @VijaykumarHadalgi Yes, except the OP actually *did* have an older backup which changes the question entirely :) – lc. Dec 09 '13 at 06:35
  • 3
    Accidents are less likely to happen if you use permissions to restrict actions.... – Mitch Wheat Dec 09 '13 at 06:42

0 Answers0