Solved

Recover back the data from .bak

Posted on 2001-07-19
11
792 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
  • 6
  • 5
11 Comments
 
LVL 7

Expert Comment

by:lozzamoore
Comment Utility
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
Comment Utility
lozzamoore,

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

Regards,
Wee Siong
0
 
LVL 7

Author Comment

by:weesiong
Comment Utility
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
 
LVL 7

Expert Comment

by:lozzamoore
Comment Utility
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
Comment Utility
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 7

Expert Comment

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

Author Comment

by:weesiong
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

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

13 Experts available now in Live!

Get 1:1 Help Now