Solved

Recover back the data from .bak

Posted on 2001-07-19
11
794 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
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
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

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
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.

810 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