Need help for rollback

[Former Member]

Dear all,

I have sent a wrong update command to the database from sqlstudio working in autocommit mode. That command has changed more than a thousand rows and I want to rollback the work but I can´t because of autocommit mode. What can I do if I don´t want to restore my last backup form a week ago?

Thanks in advance

Girasol

[Former Member · Accepted solution]

Hi Girasol,

sorry, you can't do this without restoring the last data backup. Your only option is to recover that data backup and then recover subsequent log backups to a point-in-time before you changed the rows (i.e. point-in-time recovery).

Thanks,

Ashwath

[Former Member · Accepted solution]

Hi Ashwath,

thanks for your reply. What program do I need to do a point in time recovery? Where can I find the steps to do it? I have only a database backup I did a few days ago.

Thanks in advance.

Girasol

[markus_doehr2 · Accepted solution]

You can do that using DBMGUI (just follow the recover wizard). This works only if you database is not in "Log overwrite" mode.

--

Markus