Recover deleted database from sqlserver12

Question

Unfortunately i deleted my database from sqlsever2012, how can i get that database with all tables and stored procedure

Gnanavel Sekar · Answer

if you have .MDF / .LDF means try to restoring again or http://solutioncenter.apexsql.com/recover-sql-server-data-from-delete-truncate-drop/ https://blog.sqlauthority.com/2014/06/09/sql-server-how-to-recover-sql-database-data-deleted-by-accident/

Daniel Jones · Answer

Do you have a backup? If so, restore from this. If not, then you need to use third party SQL recovery tool (http://www.repair-sql.net/) to recover your deleted data.

Nitin Sontakke · Answer

If you have dropped your database alongwith it's .mdf and .ldf files and have not taken any back-up, I don't think you can get it back. If you do, please do let me know.

Prashant Kumar · Answer

Hi, See below link to get answer about backup and restore: https://blog.sqlauthority.com/2007/07/18/sql-server-restore-database-without-or-with-backup-everything-about-restore-and-backup/ https://blog.sqlauthority.com/2014/06/09/sql-server-how-to-recover-sql-database-data-deleted-by-accident/ https://www.codeproject.com/Questions/285565/can-i-recover-deleted-data-from-Sql-Server-tables Thanks,

Recover deleted database from sqlserver12

Answers (4)