That's not a responce to a query of su_kumar11 directly, he asked 5 years ago 🙂 But for those who will have such an issue. There is a way to recover missing data by using Transaction Logs and LSNs (Log Sequence Numbers). There are few steps what you need to do - http://sqlbak.com/blog/recover-deleted-data-in-sql-server/[/url]