Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how to rollback from query analyzer? URGENT

Posted on 2003-11-25
9
Medium Priority
?
300 Views
Last Modified: 2006-11-17
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.....
0
Comment
Question by:wankidi
  • 4
  • 3
7 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 720 total points
ID: 9822533
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
 
LVL 34

Expert Comment

by:arbert
ID: 9822537
That is assuming you used implicit transactions and didn't explicitly code a BEGIN TRANSACTION without an ending COMMIT TRANSACTION....
0
 

Author Comment

by:wankidi
ID: 9822838
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 34

Expert Comment

by:arbert
ID: 9822852
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
 

Author Comment

by:wankidi
ID: 10526662
I had to restore my datbase  manually  each and every record..

0
 

Author Comment

by:wankidi
ID: 10526671
How do i get my points back ?
0
 
LVL 34

Expert Comment

by:arbert
ID: 10526907
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question