how to rollback from query analyzer? URGENT

hi

i have updated my database without using any where  condition. from  query ana;yzer .and it updated all my database .. how can i roll back...?  plz  help.....this is very important database.....
wankidiAsked:
Who is Participating?
 
arbertCommented:
You can't without a restore.  If you didn't explicitly start a transaction, you can't roll it back.

You'll have to do a point in time restore of the database from the time before you made the slip.
0
 
arbertCommented:
That is assuming you used implicit transactions and didn't explicitly code a BEGIN TRANSACTION without an ending COMMIT TRANSACTION....
0
 
wankidiAuthor Commented:
can u tell me  more about point in time restore....i dont have back copy of  the database, i have already started restoring changes manually..
>>You'll have to do a point in time restore of the database from the time before you made the slip. <<
thank u



0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
arbertCommented:
You have to have a backup to do a point in time restore.  Not to mention that the database recovery mode has to be set to full.

There are also a couple of tools that will let your "selectively" rollback transaction from the logfile--you just have to buy them.  Logexplorer is one http://www.lumigent.com and netiq also has a product http://www.netiq.com


So, no backup, no restore....
0
 
wankidiAuthor Commented:
I had to restore my datbase  manually  each and every record..

0
 
wankidiAuthor Commented:
How do i get my points back ?
0
 
arbertCommented:
What do you mean?  Your question was answered....You did exactly what I said in my first post--restore...I also listed a tool that would allow you to do a selective restore from the transaction log....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.