Problem with Object Level Recovery using 7.1.0.214
ChrisAVWood
Posts: 361
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
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
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.
This is no longer an issue for me.
Chris