Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Does SQLSERVER2008 offer Object level recovery Expand / Collapse
Author
Message
Posted Thursday, September 24, 2009 4:30 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:17 AM
Points: 48, Visits: 240
Friends,

I have been using a third party toll that offers excellent object level recovery from the compressed backup file, whereby individual tables can easily be restored from the latest available backup file.

I can find that by default SQL2008 itself offers compression technique which is actually more better than the current tool am using. But any idea if SQL2008 offers the same object level recovery technique or any alternate method by which the tables can be restored easily from the backup file without creating temporary databases and transferring db through SSIS.

Thanks
Eben

Post #793155
Posted Thursday, September 24, 2009 4:54 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:58 AM
Points: 2,698, Visits: 1,129
Third party tools are normally used, Object level restores are not supported in sql server yet.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #793165
Posted Tuesday, September 29, 2009 6:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:17 AM
Points: 48, Visits: 240
Hi,

Thanks for the info
Post #795062
Posted Wednesday, May 22, 2013 12:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 18, 2014 5:23 PM
Points: 192, Visits: 408
Resurrecting this thread with a question I have...

Can someone explain why SQL Server doesn't support object level recovery in a native manner?

How do 3rd party vendors make this possible?

I'm just looking for general knowledge here.

Thanks!
Post #1455641
Posted Wednesday, May 22, 2013 1:57 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 12,905, Visits: 32,165
AmarettoSlim (5/22/2013)
Resurrecting this thread with a question I have...

Can someone explain why SQL Server doesn't support object level recovery in a native manner?

How do 3rd party vendors make this possible?

I'm just looking for general knowledge here.

Thanks!


the 3rd part apps read the transaction log and/or full backup, and compare it to your current object(s);
from there the 3rd party application can produce the appropriate insert/update/delete statements based on comparing the two objects), sometimes by creating a script based on the log changes, sometimes based on just comparing values.

While technically no different than you restoring a backup, and comparing two tables yourself, and generating the appropriate scripts based on your own analysis, such third party tools can save you enormous amounts of time you'd spend on analysis and scripting out the changes, assuming you have a backup strategy in place before the data gets stepped on and needs to be restored.








Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1455677
Posted Wednesday, May 22, 2013 3:04 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 40,207, Visits: 36,616
AmarettoSlim (5/22/2013)
Can someone explain why SQL Server doesn't support object level recovery in a native manner?


Because doing so would allow a native restore to result in a transactionally inconsistent database (imagine restoring the Client table and Invoices tables but not the Sales table, could mean that afterwards a client has an invoice for items that are not recorded as sold.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1455725
Posted Thursday, May 23, 2013 2:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 3:20 AM
Points: 196, Visits: 650
Maybe SQL12 will steal flashback :o

Dird



Dird // Junior DBA
11g OCA
10.5 newbie
Post #1455883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse