SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Does SQLSERVER2008 offer Object level recovery


Does SQLSERVER2008 offer Object level recovery

Author
Message
ebenraja
ebenraja
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 Visits: 258
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
Silverfox
Silverfox
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4062 Visits: 1161
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
ebenraja
ebenraja
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 Visits: 258
Hi,

Thanks for the info
AmarettoSlim
AmarettoSlim
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 539
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!
Lowell
Lowell
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35746 Visits: 40231
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

GilaMonster
GilaMonster
SSC Guru
SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)

Group: General Forum Members
Points: 114010 Visits: 45460
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, MVP, M.Sc (Comp Sci)
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


Dird
Dird
Say Hey Kid
Say Hey Kid (669 reputation)Say Hey Kid (669 reputation)Say Hey Kid (669 reputation)Say Hey Kid (669 reputation)Say Hey Kid (669 reputation)Say Hey Kid (669 reputation)Say Hey Kid (669 reputation)Say Hey Kid (669 reputation)

Group: General Forum Members
Points: 669 Visits: 814
Maybe SQL12 will steal flashback :o

Dird


Dird
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search