Solved

Recover back the data from .bak

Posted on 2001-07-19
11
796 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

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…
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…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

820 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