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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
arbertCommented:
That is assuming you used implicit transactions and didn't explicitly code a BEGIN TRANSACTION without an ending COMMIT TRANSACTION....
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



Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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....
wankidiAuthor Commented:
I had to restore my datbase  manually  each and every record..

wankidiAuthor Commented:
How do i get my points back ?
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....
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.