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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
can you check eventviewer sql error log; Netbackup error log and post result?
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
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.  

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.