SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to Recovery Data Lost In Query Analizer
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

CLages
Posting Yak Master

Brazil
116 Posts

Posted - 10/26/2005 :  06:41:36  Show Profile  Reply with Quote
hi
how to Recovery Data Lost In Query Analize by mistyped command?
ex. in QA i typed

delete from Tablex where id=90

but by mistake i typed id=900

Is there any way to recovery all rows deleted where Id=900?

Tks

C. Lages

madhivanan
Premature Yak Congratulator

India
22755 Posts

Posted - 10/26/2005 :  06:54:18  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
See if this helps you
http://sqlteam.com/forums/topic.asp?TOPIC_ID=55109

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

CLages
Posting Yak Master

Brazil
116 Posts

Posted - 10/26/2005 :  07:53:04  Show Profile  Reply with Quote
I have a Database backup.
but i lost some rows from only one table.

i was thinking to get back from LoG. Is it Possible ?

If dont, i have to attach the backup whith other name and Export
this few rows from backup to main Table.
of course if there is a easy way i would like to know.

Tks
Clages

Go to Top of Page

activecrypt
Posting Yak Master

Germany
165 Posts

Posted - 10/26/2005 :  07:59:48  Show Profile  Visit activecrypt's Homepage  Send activecrypt a Yahoo! Message  Reply with Quote
Hi,
you need to do it with third party tools to recover / revert transactions like log explorer


HTH

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/27/2005 :  01:15:51  Show Profile  Reply with Quote
"i was thinking to get back from LoG. Is it Possible ?"

If you are running Transaction Logs yes. If your database's Recovery Model is set to "SIMPLE" then you can only recover these rows UPTO the time of your last full backup.

IF you have transaction log backups then make an additional TLog backup (if you don't already have one from AFTER the accident)

Recover the last FULL backup to a new, temporary, database

IF you have TLog backups restore them in sequence UPTO THE POINT JUST BEFORE THE ACCIDENT

Then insert the rows from there back into your table:

INSERT INTO MyRealDatabase.dbo.Tablex
SELECT *
FROM MyTemporaryDatabase.dbo.Tablex
WHERE id=900

Kristen
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000