Current location - Loan Platform Complete Network - Big data management - Can records in SQL Server 2008 database be recovered after deletion with delete statement
Can records in SQL Server 2008 database be recovered after deletion with delete statement
Heh, if you have made a backup before deleting, then you can recover from the backup.

If your database schema is full or high volume logging, you may also be able to recover it, it is said that you can recover the data from the logs, but, I don't know the method.

Before the general operation, you can select the data once according to the conditions of delete, and then change it to delete after meeting the requirements, or simply select into a temporary table first for the data to be deleted, and then drop the temporary table after checking that there is no error.