Hi,
I am getting this error when restoring the backup file
USE [master]
RESTORE HEADERONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak';
RESTORE FILELISTONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak';
RESTORE DATABASE [my_schema]
FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak'
WITH FILE = 1;
GO
(1 row(s) affected)
Msg 3241, Level 16, State 13, Line 4
The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 4
RESTORE FILELIST is terminating abnormally.
Msg 3241, Level 16, State 13, Line 6
The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS08R2WIN12\MSSQL\Restore\my_schema.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 6
RESTORE DATABASE is terminating abnormally.
If the backup is from Sql server 2012, how can I restore the backup file into Sql server 2008 DB?
http://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html
You may need to find some alternative way to do this.