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

Solved/Closed
gioacchinolupi Posts 1 Registration date Monday June 22, 2015 Status Member Last seen June 24, 2015 - Jun 24, 2015 at 11:35 AM
GervaseParrish Posts 2 Registration date Monday June 22, 2015 Status Member Last seen June 26, 2015 - Jun 26, 2015 at 08:27 AM
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 June 22, 2015 Status Member Last seen June 26, 2015 1
Jun 26, 2015 at 08:27 AM
See if the following article would help:
http://community.office365.com/en-us/f/172/t/266070.aspx
1
GervaseParrish Posts 2 Registration date Monday June 22, 2015 Status Member Last seen June 26, 2015 1
Jun 25, 2015 at 12:18 PM
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.
0