May 16, 2006 at 2:49 am
Hello everybody,
I have a situation where I need your thoughts on how to recover the database.
I have a dts process which would insert, update on several tables in the database, and all the data is committed. After a day I realize that dml operations are completely wrong and meanwhile the applications accessing the database were doing the dml operations as normal.
Now, how do I recover my database which would look as before the dts process kicked off, and with the changes happened in one day, discarding the dts made changes.
Can somebody help me in getting my logic going?
Viking
May 16, 2006 at 11:39 am
Your options depend on how your backup and recovery plan is set up.
Do you want the database to retain the changes made by applications and discard the changes made by the DTS package?
What recovery model is the database set to?
Do you have a log reader tool like Lumigent Log Explorer?
Greg
Greg
May 17, 2006 at 9:07 am
And do you have a full backup & uninterrupted transaction log backups from before the problem occured ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply