Solved

URGENT: Want to extract data from a MS-SQL backup file

Posted on 2004-08-04
10
1,922 Views
Last Modified: 2008-02-01
Hi all,
I have received a Microsoft SQL Database file (without extension). I want to retrieve information from this file but I don't have a Microsoft SQL Server, just a MySQL database where I want to migrate data to.
It doesn't matter if I can't migrate directly, just want to retrieve data from backup file in any format, let say, in CSV, is there any free or shareware tool to do this?
Thanks in advance,
Jaime.
0
Comment
Question by:Jaime Olivares
10 Comments
 
LVL 9

Expert Comment

by:crescendo
ID: 11721139
No, but you can download the "free" MSDE, the "desktop edition" of SQL Server, which is fully functional for what you want and will run on any modern PC.
0
 
LVL 7

Assisted Solution

by:FDzjuba
FDzjuba earned 20 total points
ID: 11721140
what is this file you have received? backup or just straight forward copy of database

if this is database then i doubt you can do it manually without sql server or special tools, (not that i know of any that will allow this)

how big is your database backup file, i got MS SQL and can install mysql to play around with
0
 
LVL 9

Accepted Solution

by:
crescendo earned 480 total points
ID: 11721146
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 55

Author Comment

by:Jaime Olivares
ID: 11721174
crescendo:
Thanks, I will try it, can you provide me the link?

FDzjuba:
It is a file with no extension, I have read with an hex editor and says "TAPE" ......."Microsoft SQL Server" .... and continues legible fields, and data.
>how big is your database backup file, i got MS SQL and can install mysql to play around with
It is just 11 Mb, I preciate your offer, I will try MSDE first if possible.
0
 
LVL 4

Expert Comment

by:Greg Rowland
ID: 11721640
Gee,
  Try to find a trial Versoin CD of SQL  server some where, like,

http://www.microsoft.com/sql/evaluation/trial/default.asp?SD=GN&LN=EN-US&gssnb=1

HTH,

G
0
 
LVL 55

Author Comment

by:Jaime Olivares
ID: 11721776
Ok, I have downloaded MSDE and now is running.
I have downloaded MSDE Plus as a tool.
Now I want to restore from file but I have not a pre-existent database. Is that possible?
I can't find an option to do that.
Or maybe need another MSDE utility.
0
 
LVL 9

Expert Comment

by:crescendo
ID: 11721799
You just need to create a database first, use the same name as the original, and put the files in the same place if possible.
0
 
LVL 55

Author Comment

by:Jaime Olivares
ID: 11721822
I have created database with the same name using MSDE
I don't see a restore function in MSDE Plus, this can be made with an SQL sentence? If yes, please give me an example.
BTW. I don't know table filenames, I can see some with the hex editor, but maybe miss some.
0
 
LVL 9

Expert Comment

by:crescendo
ID: 11721860
Example from Books Online:

RESTORE DATABASE MyNwind
   FROM C:\YourBackupFileName
   WITH NORECOVERY,
      MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf',
      MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf'
RESTORE LOG MyNwind
   FROM C:\YourBackupFileName
   WITH RECOVERY

But you have to know the logical name of the data (MyNWind) and log (MyNWindLog1) files. You can get this by executing:

RESTORE FILELISTONLY
FROM C:\YourBackupFileName


0
 
LVL 55

Author Comment

by:Jaime Olivares
ID: 11721904
I got it!!! (before crescendo's last post) I downloaded teratrax database and restored in the MSDE.
Thanks to all.
Jaime.

0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Download ms sql express. 2 27
tools to scan a SQL server's problem 14 27
HTML <font style="color:red"> 9 32
Stored Procedure needs owner to execute 5 19
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

837 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