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.
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.
- 已建议为答案 Sean GallardyMicrosoft Community Contributor, Editor 2012年4月30日 20:01
- 已标记为答案 amber zhangModerator 2012年5月7日 6:13