asked on

TEMPDB got deleted SQL 2012

I just got a frantic call from IT. It appears that someone had gone into a backup program(Backup Exec) and had clicked on what was the 'F' drive, got a prompt about formatting the drive and clicked 'Yes'. The problem was the drive he wanted to format was the 'G' drive, the 'F' drive had all the SQL data including the tempdb. Equally disturbing was the fact that all backups go to the drive he just formatted so there are no backups to restore since they did no cloud backup or even external drive backups. So now they expect me to be a miracle worker and restore the data. My question here is how can I at least recreate the tempdb database so I can get SQL 2012 back up and running?

SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rwheeler23

ASKER

They were using something called EasyUS to try to recover the data. If the data can be recovered, someone keeps their job. If not, the most recent updates are a week old and I have a long day ahead of me tomorrow.

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rwheeler23

ASKER

They are running EasyUS to try to recover. It has been running for the past 12 hours.

rwheeler23

ASKER

Thanks for offering the advice. The IT staff lives to see another day.

Scott Pletcher

Woohoo! P.S.: You really should strongly consider adding daily backups of all dbs, including system ones, to your processes.

rwheeler23

ASKER

That was my advice to these folks. I told them to at least get an external drive for now but then to look into cloud backup. I almost passed out when they told me they had no backups! In today's day and age that is unforgivable.