Solved

Recover back the data from .bak

Posted on 2001-07-19
11
802 Views
Last Modified: 2007-11-27
Experts,

I have a SQL Server .bak file, now i want recover back the data, how?

Regards,
Wee Siong
0
Comment
Question by:weesiong
[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
  • 6
  • 5
11 Comments
 
LVL 7

Expert Comment

by:lozzamoore
ID: 6301516
Which version of SQL?

In SQL7, choose restore database from tools menu.

Pick a name for the database in restore as database.
Choose 'from device', select devices, browse to the bak file.

Done!

There are a couple of other options that need to be set depending on exactly what you are doing. Let us know how you get on with this first.

Cheers.
0
 
LVL 7

Author Comment

by:weesiong
ID: 6304166
lozzamoore,

Thanks for response, i will check in monday working day for you.

Regards,
Wee Siong
0
 
LVL 7

Author Comment

by:weesiong
ID: 6311151
lozzamoore,

I have follow your way, and step by step like follow the SQL Server online book, but still got this error:

The file 'E:\MSSQL7\data\asia.mdf' canot be used by RESTORE. Consider using the WITH MOVE option to identify a valid location for the file.
Backup or restore operation terminating abnormally.

Actually i no any database in the server now, the .bak file is i get from my client site, he want me help him setup a SQL Server database in my company to help him re write the code. i am newbabies in sql server, please help me, thanks.

Regards,
Wee Siong
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 7

Expert Comment

by:lozzamoore
ID: 6311584
When you back up any database using SQL7/2000, within the backup file it stores the location of the devices at the time of the backup.

For example, you back up a database called: asia.

The files it uses on the server you perform the backup from are: data=e:\mssql7\data\asia.mdf
          log=f:\trans\asia.ldf

Now you take the bak file and restore this to a new server.

If the server has no E: drive, or the folder e:\mssql7 does not exist, or is not appropriate, you can restore the database and at the same time move the data and log devices to a new location, using the move option.

This can be done through Enterprise Manager, using the 'Options' tab. See the section 'Restore database files as:'

Hope this helps.

0
 
LVL 7

Author Comment

by:weesiong
ID: 6311603
lozzamoore,

Thank you the comments, i will try now. Can you give me your ICQ or MSN, i can tell you what problem i meet in real time, thanks.

Regards,
Wee Siong
0
 
LVL 7

Expert Comment

by:lozzamoore
ID: 6311615
I am at work at the moment, those things are blocked.
Email is: lozzamoore@yahoo.com
0
 
LVL 7

Author Comment

by:weesiong
ID: 6311641
lozzamoore,

Thank you, your way have help me restore 2 .bak file, but other 2 .bak file it got this error:

Error 3242: The file on device 'C:\MSSQL7\BACKUP\bottomframe.bak' is not a valid Microsoft Tape Format backup set.
Backup or restore operation terminating abnormally.

Regards,
Wee Siong
0
 
LVL 7

Expert Comment

by:lozzamoore
ID: 6311721
Sounds like this was backed up from SQL 6.5? or the file is corrupt.

The SQL 6.5 backup format is not compatible with SQL7/2000.

You will have to use DTS to move objects from SQL 6.5

Thanks.
0
 
LVL 7

Author Comment

by:weesiong
ID: 6311742
lozzamoore,

I am no sure, but the ex-server is use SQL Server 7.0, so how to solve the problem?

Regards,
Wee Siong
0
 
LVL 7

Accepted Solution

by:
lozzamoore earned 150 total points
ID: 6311862
Do you have access to the old 7 server still?

Run the backup again if so.

You can also try running the command:
restore headeronly from disk='<path to bak file>'

This should tell you what version the backup file is.
Software Version Major/Minor/Build columns.

Thanks.
0
 
LVL 7

Author Comment

by:weesiong
ID: 6311895
lozzamoore,

I canot Run the backup again, coz this is no our server, but i will ask the server administator to help me do this, thanks the comment :)

Regards,
Wee SIong
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

630 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