Recycle bin in SQL server.

Question

Hi All,

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.

Kindly reply...

 

---

Asheesh pandey

Answer 1

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.