Redirect restore of SQL database fails with the media family on device is incorrectly formed.

Article:TECH144288  |  Created: 2010-11-16  |  Updated: 2011-10-04  |  Article URL http://www.symantec.com/docs/TECH144288
Article Type
Technical Solution


Subject


Error



Debug log from Media Server beremote.log

10600] 11/12/10 16:10:08 SQL Error GUID: c733a63
[10600] 11/12/10 16:10:08 SQL Error Source: Microsoft OLE DB Provider for SQL Server
[10600] 11/12/10 16:10:08 SQL Error Description: RESTORE DATABASE is terminating abnormally.
[10600] 11/12/10 16:10:08 SQL Error State: 42000
[10600] 11/12/10 16:10:08 SQL Error Number: 3013
[10600] 11/12/10 16:10:08 SQL Error GUID: c733a63
[10600] 11/12/10 16:10:08 SQL Error Source: Microsoft OLE DB Provider for SQL Server
[10600] 11/12/10 16:10:08 SQL Error Description: The media family on device 'MHO_Aug21_2010_00__8e75318f_923e_4de3_a6c6_e42d373fe964_' is incorrectly formed. SQL Server cannot process this media family.
[10600] 11/12/10 16:10:08 SQL Error State: 42000
[10600] 11/12/10 16:10:08 SQL Error Number: 3241
 


Cause



The error occurs if the versions of SQL are different .

 


Solution



 

Make sure to restore to the same version and patch level of SQL.  Verify the account for Backup Exec has full admin rights to the SQL server.


Supplemental Materials

SourceUMI
ValueV-79-57344-33938
Description

An error occurred on a query to database.The media family on device is incorrectly formed. SQL Server cannot process this media family.



Article URL http://www.symantec.com/docs/TECH144288


Terms of use for this information are found in Legal Notices