October 16, 2013 at 9:51 am
We have SQL Server 2012 running on Windows Server 2008. In Oracle, if a table is accidently dropped, you can retrieve it from the Oracle Recyclebin, if table rows are accidently deleted you can get them back using Oracle Flashback. My question is, how can you recover from these two situations using SQL Server?
Also, is there a way to restore just a database object?
As far as I know, with both of these situations, you would have to restore a backup to recover the object or data rows needed. Just trying to learn if there are other (less time consuming) methods to handle these situations.
Thanks, Kevin
October 16, 2013 at 10:15 am
I don't know of a way to do it without a backup. It would be nice. And if you could restore that deleted record what if there were triggers that deleted rows in other tables. How would you get those back as well?
October 16, 2013 at 1:16 pm
It can be done with 3rd party tools, such as Quest/Dell NetVault LiteSpeed. Probably others as well.
October 17, 2013 at 7:47 am
We can put maintenance task to take differential backup for 1 hr or half an hour. Then we can restore that differential backup to existing backup. That may useful for you....
Manik
You cannot get to the top by sitting on your bottom.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply