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?
Who is Participating?
You are not sure what was backed up. Ok, find someone who does or a netbackup-way to see what is.

My question was 'what are you trying to restore from that backup?' To where? Is that sql server 2005 still a running environment? You can check if there was realy a sql backup, not a backup of sql, in database and even to where it was written.

true scrip ... so maybe sharing the script can help.
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.
AndyPandyAuthor Commented:

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.
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Eugene ZCommented:
can you check eventviewer sql error log; Netbackup error log and post result?
Eugene ZCommented:
the error 31073 can be homemade  - specified by code designer
AndyPandyAuthor Commented:
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.
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:

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.  

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.