I have accidentally executed a procedure without where
clause. Can I get the data back.
The backup of database was taken a week before.
Is there any way to get the data back by using rollback
.
I am using SQL Server Management Studio 2012
Taken from comments. When your database is in full recovery mode, you can restore your database back to a point in time (thanks to transaction logs). Therefore, going back before you accidentally executed your sql shouldn't be a problem. Here is nice answer how to do that.