If I restore a database and overwrite the original is there any way to go back? SQL Management Studio

Question

I do not have a backup available but I wrote over an existing database with a backup file.

The problem is the one I wrote OVER had a Stored Proc that I need to get back. Any way to do this without a backup file of the database with the Stored Proc in it?

Answer 1

Basically the answer is no.

It might be worth looking in your %temp% directory though at the files entitled ~....sql just in case you are extraordinarily lucky.

I have SSMS toolspack installed and that keeps a log of all SQL statements executed in Management Studio which might have been useful in this instance.

Answer 2

Not unless you have a copy of the script that created the proc in the first place.