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

Problem

Job log shows

 

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

 

Error Message

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.


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)