Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
CLages
Posting Yak Master
116 Posts |
Posted - 2005-10-26 : 06:41:36
|
hihow to Recovery Data Lost In Query Analize by mistyped command?ex. in QA i typed delete from Tablex where id=90but by mistake i typed id=900Is there any way to recovery all rows deleted where Id=900?TksC. Lages |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
CLages
Posting Yak Master
116 Posts |
Posted - 2005-10-26 : 07:53:04
|
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.TksClages |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-26 : 07:59:48
|
Hi,you need to do it with third party tools to recover / revert transactions like log explorerHTH-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-27 : 01:15:51
|
"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, databaseIF you have TLog backups restore them in sequence UPTO THE POINT JUST BEFORE THE ACCIDENTThen insert the rows from there back into your table:INSERT INTO MyRealDatabase.dbo.TablexSELECT *FROM MyTemporaryDatabase.dbo.TablexWHERE id=900 Kristen |
|
|
|
|
|