Scripting of Object Level Recovery?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Scripting of Object Level Recovery?

Postby wayneph » Thu Feb 06, 2014 12:56 am

I have a few PeopleSoft databases that each contain 20,000+ tables in them. Occasionally we do something in a development environment where we want to restore tables from the last back up. With the size of the database, we can occasionally run into space issues, not to mention the fun of scrolling through a GUI to select tables out of a list that long.

Is there any way to script the Object Level Receovery?

The one or two times I tried the wizard, I ended up backing out and just finding somewhere to restore the entire database. I am hoping that I am just missing something.

Thanks,
Wayne
--wayne
wayneph
 
Posts: 17
Joined: Thu Jul 19, 2007 2:57 pm

Postby chriskelly » Fri Feb 07, 2014 5:24 pm

Unfortunately the Object Level Recovery functionality cannot be scripted. And as you have found, it doesn't handle large database schemas especially well.

I would recommend that you keep doing the full restores to get to your objects. There is the option of using SQL Compare and SQL Data Compare to copy any objects and the data to another database. These are far more reliable.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests