Solved

SQL Server 2008 Restore Database

Posted on 2011-02-24
4
1,308 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:tsprks
4 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 167 total points
Comment Utility
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
 

Author Comment

by:tsprks
Comment Utility
Can you possibly give me a sample script to do a FULL backup to DISK?
0
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 166 total points
Comment Utility
BACKUP DATABASE [DBNAME] TO DISK='C:\BACKUPNAME.BAK' WITH STATS=3

Open in new window

0
 
LVL 9

Assisted Solution

by:mayank_joshi
mayank_joshi earned 167 total points
Comment Utility
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

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now