Hi, I am getting the following error message yesterday when I restored one Database onto another server. >Msg 3241, Level 16, State 0, Line 1 The media family on device E:\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\Backup\\TestDB.bak is incorrectly formed. SQL Server cannot process this media family. >Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. I didn't change anything on Server and both server has the same service pack. I am getting the error message on Restore Command and same in GUI as well. Any Idea? [Edit] Results of Restore Headeronly and Restore Filelistonly HeaderOnly NULL,NULL,1,NULL,0,1,2,sa,PRODUCT_01,TestDB,655,2010-08-19 11:27:10.000,3885596672,597911000000346400043,597914000003892100001,597911000000346400043,597911000000339300149,2011-09-08 15:20:28.000,2011-09-08 15:21:00.000,52,0,1033,196609,80,4608,10,0,4000,TMS_SQL_01,512,CA58D763-3748-4BE7-B107-37D262AD455D,FB445964-004E-47DE-9DB0-1C0FE5FDDF88,SQL_Latin1_General_CP1_CI_AS,1FA525B4-40F6-497C-8570-B2AA938C297B,0,0,0,0,0,0,0,0,0,0,FB445964-004E-47DE-9DB0-1C0FE5FDDF88,NULL,FULL,NULL,NULL,Database,01C2B429-6B28-4CD4-8ED6-1F808989997F,3885596672 FilesOnly DataTakeon_Data,E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDB.mdf,D,PRIMARY,30774198272,35184372080640,1,0,0,00000000-0000-0000-0000-000000000000,0,0,3804889088,512,1,NULL,597911000000339300149,463A52B5-02E3-497E-B9A4-632F63423AA0,0,1,NULL DataTakeon_Log,F:\SQL_Server_Logs\TestDB.ldf,L,NULL,20925841408,35184372080640,2,0,0,00000000-0000-0000-0000-000000000000,0,0,0,512,0,NULL,0,00000000-0000-0000-0000-000000000000,0,1,NULL
What are the results to these queries /* verify backup set is valid */ RESTORE VERIFYONLY FROM DISK = N'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\TestDB.bak' /* list backups within device */ RESTORE HEADERONLY FROM DISK = N'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\\Backup\TestDB.bak'' /* list file names in backup set */ RESTORE FILELISTONLY FROM DISK = N'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\TestDB.bak''
From reading all the comments you might want to update your question with everything that you have done and output from the questions/comments, so everyone knows what has happened so far. Can you combine all the output from the BACKUP argument commands @Fatherjack provided and add those to your question as well? ServerA is the original instance where the backup came from, you are trying to restore that database backup to a new (or existing database) on ServerB? You can restore this backup to ServerA but with a different database name? Then a few things to check to just be sure...What was the result of the last DBCC CHECKDB command on the original database (was it clear of errors)? If you create a new database on ServerB, back it up, and then try and restore it with the same command you are using for the other backup do you get the same results?
OK, the problem is the location of the database files. Your backup is expecting to restore the mdf to the E:\ and the Log file to the F:\. I am guessing that you dont have both of those drives on your machine where you are trying to restore. Try executing a restore using the MOVE argument. Assuming you want to restore both mdf and ldf to the same drive which is labelled E:\\ the command would be RESTORE DATABASE TestDB FROM DISK=N'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\TestDB.bak' WITH MOVE 'DataTakeon_Data' TO 'E:\DatabaseDirectory\DataTakenon.mdf', MOVE 'DataTakeon_Log' TO 'E:\DatabaseLOGDirectory\DataTakenon.ldf'