February 12, 2014 at 1:56 pm
We are using SQL Server 2012 EE SP1 on Windows Server 2008. We were looking for a method to be able to restore SQL Server Database Objects (i.e. tables). We did not see a way to do this within SQL Server. However, someone pointed us to Idera SQLSafe and stated that it allows for object level recovery. We wanted something comparable to Oracle Flashback Query (which allows you to recover deleted rows) and Recyclebin (which allows you to recover deleted objects). We know SQL Server has SQL Server Database Snapshots but it is not the same as the Oracle Features.
Has anyone used any of the Idera SQLSafe's Products for object level recovery? Which Product? How does it work? Is there a performance hit (i.e, disk space, i\o, cpu, etc.)?
Thanks, Kevin
February 13, 2014 at 5:40 am
I use the Litespeed suite including OLR. The Litespeed OLR is helpful, but as table object sizes grow, performing an OLR restore can take just as long as restoring the whole database 😀
Although, if you restored the whole database as a temporary database, you'd still then have the overhead of moving the millions of rows to the target table in the target database, so i suppose it's still quicker with OLR.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2014 at 8:23 am
Idera's product works. But it will cause hits to i/o and you will have to have storage available for it, although not initially.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply