SQL Sever 2012

Question

Dear Sir,

Due to some mistake, I have applied the drop command in SQL server 2012, my all data is lost and my database is so much important. Please guide me on how may take back my all data including table structure and data.

It's very urgent help I need.

Answer 1

Hi there,

so you droppped the whole database?
In that case you need to restore your database from a valid backup.
I hope that appropriate backup jobs where setup before, either native or through a 3rd party backup software which may is in use.

If your SQL Server resides in a VM and the whole VM is backed up from time to time than you may extract the data and log file of the database from there as well.
But keep in mind: data loss is inevitable (time gap between last succesful backup and drop command).

Answer 2

The only way i see is restore the backup of the database using full and log backups on same instance as different name, script out table structure from new database restored and create table on old database from which table was dropped. Now use import export wizard to move data from new database to old.

You can also try to restore the whole database but in this case the whole database will be unavailable during the restore period.

Answer 3

Hi @Bhatt Himanshu ,

Please guide me on how may take back my all data including table structure and data.

What command do you use? You mean you drop one database? Or drop one table?
If you have one backup, try to restore the backup files.If do not have one, you have to recreate it.

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 4

Hi @Bhatt Himanshu ,

Is the reply helpful?

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.