SQl backup files getting corrupted when backed up from NetApp CIFS share

We have VERITAS NetBackup 7.6.0.2 backing up data on several NetApp CDOT 8.3.2P3 CIFS shares.

The SQL servers run automated maintenance plans that back the databases up to folders on a CIFS share.  We then backup this Cifs share using NetBackup, via the UNC.  This has worked for five years (we only upgraded to 8.3 and CDOT in the past 12 months but we MUST have had a restore in this time period.)

The .bak file which we restore to disk from tape is exactly the same size but does not pass an MD5 Checksum and shows as being corrupt if we try to do a SQL restore from it.

If we do a SQL restore from the .bak file on the CIFS share all is well.  If we manually copy the .bak file to another share or folder we can also restore it.   I tried copying a .bak file to a local drive on the media server and backing THAT up and restoring it to another local drive and that worked fine.  the MD5 Checksum passed.

I have tried other CIFS shares as the source and destination to no avail.  I also tried backing up from a CIFS share and restoring to a local folder with no success.  

Data de-duplication and compression are enabled on the SQL backup volume but I have had similar issues on volumes where I have disabled those features.  Furthermore there has not been time for de-duplication or compression to run in my testing today.

This issue exists in databases from SQL 2005 through 2014.

I have no such issue with the other file types which I have tried.

Has anyone seen this issue before?
LVL 1
CharlesHAsked:
Who is Participating?

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

x
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.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
you may need to rollback from ver  8.3 and contact vendor support
0
CharlesHAuthor Commented:
Thanks Eugene Z,  that would probably work as well.

It was a basically bug with NetBackup 7.6.  we finally managed to convince the higher-ups to let us purchase an upgraded version of NetBackup and all is well.

We had a problem for a while with NetBackup only backing up the first 500 MB of large files but we got that fixed as well.   That was a setting change on the NetApps I think.  If anyone runs across it I would be happy to look it up again.
0

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
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
Microsoft SQL Server

From novice to tech pro — start learning today.