Receiving error " An Error occurred with the SQL Server. The media family on device 'PC Path' is incorrectly formed." when trying to restore a database backup

Potential Symptoms

  • Receiving error when trying to restore a database backup to a new or different computer.
    • An Error occurred with the SQL Server. The media family on device 'PC Path' is incorrectly formed. SQL Server cannot process this media family. RESTORE DATABASE is terminating abnormally.
      DatabaseError.jpg

Environment

  • Product Family: Software
  • Product:
  • Component: Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2014
  • Control System: Venus 1500 v4, Show Control

Cause

  • SQL Databases are not backwards compatible.
  • You can take a copy of a database using SQL Server 2005, and bring it forward and restore it on a SQL Server 2008 or SQL Server 2014.

Example:

'Computer A was a brand new install of 4.22.3 with Server 2014. The user needs to replace Computer A with a different computer, Computer B. They install a previous version of 4.17 or earlier to Computer B, from an old disk, which has SQL Server 2005. There was a Database backup created from Computer A.

By doing this and installing a older version of 4.17 or earlier to Computer B, it installed SQL Server 2005. Updating software to 4.18 or greater, does not update or change the SQL Server. They cannot take the database from Computer A that was using an SQL Server 2014 and put it on Computer B using a SQL Server 2005, even if they are the same Venus 1500 software version after updates.

Resolution

KB ID: DD2440159


DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.