Problem with Object Level Recovery using 7.1.0.214

Compresses, encrypts, secures and monitors SQL Server backups.

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

Problem with Object Level Recovery using 7.1.0.214

Postby ChrisAVWood » Thu Oct 04, 2012 7:50 pm

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
ChrisAVWood
 
Posts: 308
Joined: Tue Dec 18, 2007 6:18 pm
Location: Edmonton, Alberta, CANADA

Postby ChrisAVWood » Thu Oct 04, 2012 8:07 pm

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

Chris
English DBA living in CANADA
ChrisAVWood
 
Posts: 308
Joined: Tue Dec 18, 2007 6:18 pm
Location: Edmonton, Alberta, CANADA

Postby RajK » Sat Oct 06, 2012 1:51 am

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.
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am

Postby ChrisAVWood » Wed Oct 10, 2012 4:12 pm

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
ChrisAVWood
 
Posts: 308
Joined: Tue Dec 18, 2007 6:18 pm
Location: Edmonton, Alberta, CANADA


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests