Solved

Recover back the data from .bak

Posted on 2001-07-19
11
793 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
 
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
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
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

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)

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

895 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

14 Experts available now in Live!

Get 1:1 Help Now