Link to home
Start Free TrialLog in
Avatar of AndyPandy
AndyPandyFlag for United States of America

asked on

Netback restore error 31073

Restoring a SQL Server 2005 Netbackup to 2008 R2 on another windows server, via script.
Get a error ;Operation type unknown Error (31073)
Google doesn't show anything,  what does 31073 mean?
Avatar of jogos
jogos
Flag of Belgium image

To be sure: you get that error on the veritas restore action?

I can't specificly help you with netbackup errors, but is it possible to check if the backupaction that created that backup has completed without errors or warnings.

Second clarification. What are you trying to restore from that backup? Backupprograms copy files from a filesystem, If you are trying to restore a .bak-  or .trn-file  (sql server backup output) this error is strictly Veritas Netbackup. If you want to try to restore life databases (.mdf, .ndf, .ldf) I must say that this can be done, but that by attaching them the probably will give you errors.
Avatar of AndyPandy

ASKER

Jogos,

I am not sure what was backed up.   I was asked to restor e for a certain date.  I will not have access to the machine for another day.
thanks for your patience.
Avatar of EugeneZ
can you check eventviewer sql error log; Netbackup error log and post result?
ASKER CERTIFIED SOLUTION
Avatar of jogos
jogos
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks,  a coworker found a solution.  But he wont be available for a few days, so I will close this,  and update when I find out what we did differant than me.
Thanks for your assistance.
Avatar of mudasir249
mudasir249

We had the same issue and we found the following solution useful.

1. Verify the location of the file by searching the local computer for the file sqlvdi.dll

2. Verify, in the registry, that the following two keys do not exist:
HKEY_CLASSES_ROOT\CLSID\{40700425-0080-11d2-851f-00c04fc21759}\InprocServer32
HKEY_CLASSES_ROOT\CLSID\{b5e7a132-a7bd-11d1-84c2-00c04fc21759}\InprocServer32

3. Reregister the sqlvdi.dll file from the DOS prompt using the regsvr32 program. In a DOS window, go to the directory where the sqlvdi.dll file is located, and execute the following command:
regsvr32 sqlvdi.dll.  

In the example below, this was done from the C:\Program Files\Microsoft SQL Server\80\COM directory.

 

4. A pop-up message similar to the following one should appear, indicating the successful registration of the DLL file.  


Mudasir.