Does SQLSERVER2008 offer Object level recovery

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2005 » Administering » Does SQLSERVER2008 offer Object level...

Add to briefcase

Does SQLSERVER2008 offer Object level recovery

Expand / Collapse

Author

Message

Posted Thursday, September 24, 2009 4:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, December 14, 2012 3:01 AM
Points: 48, Visits: 234

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

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

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

Group: General Forum Members
Last Login: Friday, December 14, 2012 3:01 AM
Points: 48, Visits: 234

Hi,

Thanks for the info

Post #795062

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse