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

CharlesH
CharlesH used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
you may need to rollback from ver  8.3 and contact vendor support
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial