Solved

how to rollback from query analyzer? URGENT

Posted on 2003-11-25
9
295 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
9 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 180 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

713 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