SQL Server 2008 Restore Database

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.

Thanks.
tsprksAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
I believe you can't restore a "tape" file from disk. Ask them to do a FULL database backup to "DISK" then send you the bakup.bak file. Other than that you will need same tape device to load then restore the file they provided.
0
 
tsprksAuthor Commented:
Can you possibly give me a sample script to do a FULL backup to DISK?
0
 
EvilPostItConnect With a Mentor Commented:
BACKUP DATABASE [DBNAME] TO DISK='C:\BACKUPNAME.BAK' WITH STATS=3

Open in new window

0
 
mayank_joshiConnect With a Mentor Commented:
You can take Full backup to disk using the following script:-

BACKUP DATABASE [database_name] TO  DISK = N'C:\database_name.bak'  WITH NOFORMAT, NOINIT,  NAME = N'database_name-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.