Red Gate forums :: View topic - Problem with Object Level Recovery using 7.1.0.214
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

Problem with Object Level Recovery using 7.1.0.214

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



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Thu Oct 04, 2012 7:50 pm    Post subject: Problem with Object Level Recovery using 7.1.0.214 Reply with quote

Hi,

I am trying to recover individual tables from a 7.1.0.214 backup to a fresh database. I was able to recover a table with 10 million rows and now I am trying to recover 2 tables that have 8 million rows and 4 million rows from the same backup to the same fresh database. Once I confirm to recover the tables I get a System.NullReferenceException and Object reference not set to an instance of an object.

I get a Net Runtime 2.0 error event 5000 show in the Event Viewer Application log.

It takes me more than an hour to get to this part of the recovery. I have restarted the process twice now and get the same error each time.

This is recovering an SQL2005 SP4 DB on a W2K3R2 SP2 32 bit server.

Thanks

Chris
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Thu Oct 04, 2012 8:07 pm    Post subject: Reply with quote

Looks like I am running 1.2.0.32 of Object Level Recovery Pro.

Chris
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Sat Oct 06, 2012 1:51 am    Post subject: Reply with quote

Dear Chris,

Just letting you know that this has created a new support case in our support system. I will be posting a response via the support case to your query.

Thanks for your patience and feedback in this matter.
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Wed Oct 10, 2012 4:12 pm    Post subject: Reply with quote

So as not to leave this thread without answers I was told that OLR has some limitations and I was able to use SSIS to export the data once I had created a database from the backup.

This is no longer an issue for me.

Chris
_________________
English DBA living in CANADA
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