InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 21:28:30 GMT20http://www.sqlservercentral.com/Forums/Topic793155-146-1.aspxMaybe SQL12 will steal flashback :o DirdThu, 23 May 2013 02:41:00 GMTDirdhttp://www.sqlservercentral.com/Forums/Topic793155-146-1.aspx[quote][b]AmarettoSlim (5/22/2013)[/b][hr]Can someone explain why SQL Server doesn't support object level recovery in a native manner?[/quote]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.Wed, 22 May 2013 15:04:57 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic793155-146-1.aspx[quote][b]AmarettoSlim (5/22/2013)[/b][hr]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![/quote]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 [b]enormous [/b]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.Wed, 22 May 2013 13:57:11 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic793155-146-1.aspxResurrecting 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!Wed, 22 May 2013 12:25:26 GMTAmarettoSlimhttp://www.sqlservercentral.com/Forums/Topic793155-146-1.aspxHi,Thanks for the infoTue, 29 Sep 2009 06:24:41 GMTebenrajahttp://www.sqlservercentral.com/Forums/Topic793155-146-1.aspxThird party tools are normally used, Object level restores are not supported in sql server yet.Thu, 24 Sep 2009 04:54:44 GMTSilverfoxhttp://www.sqlservercentral.com/Forums/Topic793155-146-1.aspxFriends,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.ThanksEbenThu, 24 Sep 2009 04:30:25 GMTebenraja