Dear
If I delete all the records from a table then is there any way to restore those records in sql server
Printable View
Dear
If I delete all the records from a table then is there any way to restore those records in sql server
[quote=nitesh.aggarwal;28814]dear if i delete all the records from a table then is there any way to restore those records in sql server[/quote]
yes nitesh, you can by rollback transaction if have set begin transaction before deleting the records like
BEGIN TRAN
Delete from table
ROLLBACK TRAN
---v v---
Vikas Vaidya
[i][please mark it as thank if you found the answer useful][/i]
You can rollback the transactions to restore to previous state.