One method to recover deleted rows from SQL Server Apr 29, 2021 Follow these steps: Restore backup database before the deletion. Connect to database with Visual studio. Click on table and click show table data. Filter the data to the rows needed. Click Script button to generate the insert statements.