CODEWITHSUNDEEP
sqldatabasesql-server-2008copydelete-file
Fearghal
Fearghal

Reputation: 11447

SQL Server Management Studio deleted my database during copy

I was copying a database using the SQL Server Management Studio Wizard and made the mistake of deleting the SQL Server Job created to copy it whilst the job was running.

My source database has now disappeared. I did a search on my computer and used a win mapping tool to see if I could see it but no luck.

Does anybody have any ideas how I can find my database again? It surely isn't lost!

Upvotes: 0

Views: 1748

Answers (1)

usr
usr

Reputation: 171246

Search all drives for *.mdf files and review all of them. Likely, they are still there. You can attach database files to make them known to SQL Server again.

Windows Search might not have them indexed, so use Everything Search to be safe.

Upvotes: 1

Related Questions