Problem with Object Level Recovery using 7.1.0.214

[ChrisAVWood]

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]

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

Chris
_________________
English DBA living in CANADA

[RajK]

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.

[ChrisAVWood]

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