A customer has provided me with a back up file which he says is from SQL Server 2005 Compact Edition. I’m unable to restore it in either of the following instances I have on my machine
1. SQL Server 2014 (via Management Studio 2014)
2. SQL Server 2005 (via Management Studio 2005)
In both cases, if I try to use the GUI to restore, it just doesn’t show any backups in the file.
When I restore with the following backup command…
RESTORE DATABASE Framework FROM DISK = ‘C:\SQLBU\Framework.bak’
I get the following error in 2005 and 2014…
Msg 3241, Level 16, State 0, Line 3
The media family on device ‘C:\SQLBU\Framework.bak’ is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.
I download SQL Server 2005 compact edition, but the install didn’t allow me to create a named instance? (Not sure if something went wrong, I tried to google to see how the compact edition works, but it is so old I’m not getting any useful results) Can anyone tell me ‘how do I create a ‘compact edition’ instance’ (so I can try to restore to that) ? Or any other solution that will enable me to restore the .bak (so I can port it to a newer version of SQL Server)
Thanks to anyone who can help! 🙂