Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server 2005: How to restore databsae from .DBK file

Posted on 2008-10-22
5
Medium Priority
?
1,805 Views
Last Modified: 2012-05-05
Hello Everybody,

I do not have much of a experience in DB creation, backup/restoration. We have received some set of files from customer to work on his DB and one of the file is .DBK and it is of size 20GB.

So based on the size it appears to be the main database.

When i looked on the net it says .DBK file could be DBASE backup (which could not be our case) or SQL backup.

When I tried to do RESTORE FILELISTONLY with that file then I got the following error message:

The media family on device 'db_200804031804.DBK' is incorrectly formed. SQL Server cannot process this media family. Chances are file could be corrupt.


My questions are:
1. Could it be a valid SQL DB backup file??
2. And if yes then is there different way to restore such files?

Any help is greatly appriciated.

Thanks,
Resham
0
Comment
Question by:resham
[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
  • 2
  • 2
5 Comments
 
LVL 9

Assisted Solution

by:Sander Stad
Sander Stad earned 200 total points
ID: 22776281
Could you check if the RESTORE VERIFYONLY works. Maybe your file is corrupt.
 
0
 
LVL 7

Assisted Solution

by:Cedric_D
Cedric_D earned 200 total points
ID: 22777469
Install SQL 2005 SP2.

Ask customer, maybe it's not SQL2005 backup.
0
 

Author Comment

by:resham
ID: 22783268
Thanks for replying so promptly.

sstad,
I tried RESTORE VERIFYONLY as well and gives same error.

Cedric_D,
I cannot contact customer directly as there are lots of layers in between but the our customer support person says it is SQL backup and he could restore from it. I am awaiting his furthur reply as well but thought of checking on this site as there are more knowledgable people around here.

Thanks
Resham
0
 

Accepted Solution

by:
resham earned 0 total points
ID: 22783405
Hi Guys,

Thanks for your replies but I have got the answer.
Actually it is the backup of SQL Sever but taken by 'Litespeed for SQL Server' and I will have to restore using the same.

Thanks once again.

About the points, I think I should take these points to me only. If not possible then I will divide points between you two.

Resham
0
 
LVL 7

Expert Comment

by:Cedric_D
ID: 22787767
Give them to the customer who courtesely unveils mysterious file format.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
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.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

660 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