What are the challenges you face when working across database platforms? Take the survey
Options

Problem with Object Level Recovery using 7.1.0.214

ChrisAVWoodChrisAVWood Posts: 361
edited October 10, 2012 11:12AM in SQL Backup Previous Versions
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

Comments

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

    Chris
    English DBA living in CANADA
  • Options
    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.
  • Options
    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
Sign In or Register to comment.