I cannot restore a SQL Server database in a new location.

Solved/Closed
gioacchinolupi Posts 1 Registration date Monday 22 June 2015 Status Member Last seen 24 June 2015 - 24 Jun 2015 à 11:35
GervaseParrish Posts 2 Registration date Monday 22 June 2015 Status Member Last seen 26 June 2015 - 26 Jun 2015 à 08:27
Hello,


Made backup of the database on server c, SQL Server 2012, moved on to the local computer with SQL Server 2012, restore database does not work.
When checking the validity of the file on the server with the command RESTORE VERIFYONLY FROM DISK = 'C:\Food.bak' the answer is: The backup set on file 1 is valid.
But when testing on the local computer with the same command the answer is:
Message 3241, level 16, state 13, line 1
The media family on device 'C:\Food.bak" is created incorrectly. Server cannot process this media family.
MSG 3013, level 16, state 1, line 1
VERIFY DATABASE fail.
Tell me, what could be the problem?

Related:

2 responses

GervaseParrish Posts 2 Registration date Monday 22 June 2015 Status Member Last seen 26 June 2015 1
26 Jun 2015 à 08:27
See if the following article would help:
http://community.office365.com/en-us/f/172/t/266070.aspx
GervaseParrish Posts 2 Registration date Monday 22 June 2015 Status Member Last seen 26 June 2015 1
25 Jun 2015 à 12:18
The problem may be that on the local computer is not SQL Server 2012. Check the identical there are servers or not. I think that the problem can be most likely in it.