The media family on device is incorrectly formed. SQL Server cannot process this media family.
| Article:TECH163983 | | | Created: 2011-07-06 | | | Updated: 2012-07-21 | | | Article URL http://www.symantec.com/docs/TECH163983 |
| NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made. |
Problem
Microsoft SQL Database fails to restore
Error
The media family on device is incorrectly formed. SQL Server cannot process this media family.
Error seen in SQL output, dbclient log, and SQL Agent View Status:
INFO ODBC return code <-1>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]100 percent processed.>.
INFO SQL Message <3241><[Microsoft][ODBC SQL Server Driver][SQL Server]The media family on device 'VNBU0-10120-10148-1302289400' is incorrectly formed. SQL Server cannot process this media family.>
INFO SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.>
Environment
Master Server: Windows 2008 R2
Client: Windows 2008 R2 w MSSQL 2008 and higher
Netbackup 7.01 and above
Cause
1. Windows 2008 R2 is DNS sensitive to host names.
2. MSSQL is attempting to set maxtransfer and buffer
# The following image is type: Full
NBIMAGE "MSSQL.~.7.001of001.20110408095445..C"
SQLHOST "db dstclient"
NBSERVER "NBU_MASTER"
BROWSECLIENT "db scrclient"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE
Solution
All three steps are required to resolve
1. Modify the host names to match dns
2. Modify MAXTRANSFERSIZE to 0
3. Modify the NUMBUFS to 1
|
|
Article URL http://www.symantec.com/docs/TECH163983
Terms of use for this information are found in Legal Notices
Thank you.