SQL Server 2012 Rollback changes

Question

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

**(1)** if you use `BEGIN TRANSACTION`, you can `ROLLBACK` as long as you haven't called `COMMIT` yet, or if that doesn't work **(2)** restore the backup .... — marc_s, Aug 27 '15 at 11:22
@marc_s the backup was taken a week before and I want to recover data from today before 11 AM. Will it work? — Ammar Bukhari, Aug 27 '15 at 11:26
Is your database in `full recovery mode`? If it is, perhaps restore from a point in time, check this: http://stackoverflow.com/questions/16945254/how-to-perform-sql-roll-back-from-transaction-logs — Ivan Sivak, Aug 27 '15 at 11:27
@IvanSivak kindly post your comment as answer. I will mark it. — Ammar Bukhari, Aug 27 '15 at 11:54

score 4 · Answer 1 · answered Aug 27 '15 at 11:27

4

what is your database recovery model? if recovery model is full you can restore database with transaction log backup. before restoe you should execute backup from your database.

answered Aug 27 '15 at 11:27

Hadi

443
3
15

please check the below link and restore your database to a point in time https://technet.microsoft.com/en-us/library/ms190982(v=sql.105).aspx – Hadi Aug 27 '15 at 11:38

score 1 · Accepted Answer · edited May 23 '17 at 12:24

1

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.

edited May 23 '17 at 12:24

Community

1
1

answered Aug 27 '15 at 12:02

Ivan Sivak

7,178
3
36
42

SQL Server 2012 Rollback changes

2 Answers2