How to Recover Deleted rows from sql 2000 Database

[Robymon]

How to Recover Deleted rows from sql 2000 Database using with some period parameter eg: from 01/01/2012 - 20/05/2012 Display all deleted records on this period.

[Lost User]

Restore the backup. AFAIK, there's no alternative for backups.

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

[Lost User]

There is no inbuilt-mechanism to restore or read deleted rows in SQL Server 2000. You must implement logical deletes instead of physical deletes to be able to achieve that. (For example, an IsDeleted(bit) column in every table). As Eddy suggested, the only other ways is to work on a restored copy of the database.