Red Gate forums :: View topic - Scripting of Object Level Recovery?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Scripting of Object Level Recovery?

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
wayneph



Joined: 19 Jul 2007
Posts: 17

PostPosted: Thu Feb 06, 2014 12:56 am    Post subject: Scripting of Object Level Recovery? Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Fri Feb 07, 2014 5:24 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group