Monday, April 30, 2012 1:16 PM
We have seen recyle bin in Oracle 10g and it is very good feature in Oracle database but in case of SQL server is there any tool or store proc by which we can rollback our data or dropped object in database.(Default)
We have experience in sql server with Begin transaction , and whenever we use this command with update or delete statement then we can rollback deleted or changed data if required.
Monday, April 30, 2012 2:29 PM
There is no 'recycle bin' built in to SQL Server, per say, other than your transaction log backups. RedGate has a tool called 'Virtual Restore' that would make this process easier, but it still requires backups. There may some other third party tool you could use.
- Proposed As Answer by Sean GallardyMicrosoft Community Contributor, Editor Monday, April 30, 2012 8:01 PM
- Marked As Answer by amber zhangModerator Monday, May 07, 2012 6:13 AM