How can I recover database which is deleted from sqlserver [Archive]

View Full Version : How can I recover database which is deleted from sqlserver

matiul

Mar 18, 2010, 02:00 AM

I have database name doctors in sqlserver 2005. Suddenly I saw database doctors exist but inside satabase there is no table and no sp. Therefore how can I recover this.

Regards

Matiul Islam

Curlyben

Mar 18, 2010, 02:01 AM

Restore the backup.

ScottGem

Mar 18, 2010, 04:14 AM

If you haven't been backing up your database daily, you have been negligent. Are you the DBA? If so, you should know how to restore the backup. If not, talk to your DBAs.