"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
how to Recovery Data Lost In Query Analizer
Posted - 10/26/2005 : 06:41:36
