on 12-07-2007 6:41 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.