Problem with Object Level Recovery using

ChrisAVWoodChrisAVWood Posts: 361
edited October 10, 2012 11:12AM in SQL Backup Previous Versions

I am trying to recover individual tables from a 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.


English DBA living in CANADA


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

    English DBA living in CANADA
  • 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.
  • 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.

    English DBA living in CANADA
Sign In or Register to comment.