SQL Server Performance Forum – Threads Archive
Recovery Deleted Records Mssql 2000Hi All,
Currently i have a table only performing Inserting and Deleting, and the records in the table will be purged everyday. So, Is there anywhere i could recovery all the deleted records so far. Thank In Advance.
if u have all the backup then Yes, otherwise NO. Having said that, if u have backup then also it is not so easy to get all the records which are deleted. Madhu
You have to have full backup+tlog backups/diff backups… Check POINT IN TIME RECOVERY topic in BOL…
you may also get it back with third party tool like Log Rescue if your company provide sufficient budget have a loom athttp://www.red-gate.com/products/SQL_Log_Rescue/index.htm Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
As suggested if you can perform the backup in regular intervals you can take such steps,l if you are using SQL 2005 then you can take help of SNAPSHOT backups where you can keep the required data for readonly purpose. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.