I am doing some work for a client and need access to their database in order to complete my project. I had my client do a 'generic' backup of their SQL database using the GUI and send me the file (via FTP). When I try to the restore the database I a Specified Cast Not Valid error. After running 'restore verifyonly from disk='file'' I get a message stating:
Msg 3243, Level 16, State 1, Line 1
The media family on device 'file' was created using Microsoft Tape Format version 1.236. SQL Server supports version 1.0.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
How can I get around this error? My clients database is an SQL 2008 database and I'm trying to restore it on an SQL 2008 server.