Solved

SQL Server 2008 Restore Database

Posted on 2011-02-24
4
1,333 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 167 total points
ID: 34974624
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
ID: 34975662
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
ID: 34977733
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
ID: 34977752
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

724 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