Solved

SQL Server 2005 Express, I have a BAK file..I am trying to use SQL Server Manager Studio...I am getting the following error that I need mdf file but I have no...

Posted on 2009-04-15
8
223 Views
Last Modified: 2012-05-06
Hi there;

I am using SQL Server 2005 Express, I have a BAK file..I am trying to use SQL Server Manager Studio...I am getting the following error that I need mdf file but I have no mdf file...All I have is bak file...and import it successfully...Please examine the screenshots...

Best regards...
1.jpg
2.jpg
0
Comment
Question by:jazzIIIlove
  • 3
  • 3
  • 2
8 Comments
 
LVL 12

Assisted Solution

by:udayakumarlm
udayakumarlm earned 300 total points
ID: 24145568
goto options tab and change file path for both MDF and log files
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 200 total points
ID: 24145577
follow this path after creating blank database.

right click on data,
click on Restore->Database
select "From Device" radio button
add your .BAK file
once you add .BAK, check "Restore" check box beside your .BAK
Now, Go to option at left hend side
"overwrite the existing database" check box. (first checkbox)
give the page in "Restore As" section for you MDF and LDF file. (new location where you want to create DB)
leave everything default and click on OK button
0
 
LVL 12

Expert Comment

by:udayakumarlm
ID: 24145581
as shown in the figure. cahnge the restore as path
Config.JPG
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 12

Author Comment

by:jazzIIIlove
ID: 24145684
udayakumarlm:
RiteshShah:

Please examine the screenshots a), b)  and c)

udayakumarlm:

Could you give the full path? I cannot see whoe path in your screenshot...

Best regards...

a.jpg
b.jpg
c.jpg
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 24145689
Reminder: I have no *df file...
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24145694
try using one check box in first screen shot.
0
 
LVL 12

Assisted Solution

by:udayakumarlm
udayakumarlm earned 300 total points
ID: 24145696
you can specify something like c:\a.mdf or c:\dbpath\a.mdf and c:\a.ldf or c:\dbpath\a.ldf
the path must be accessable. it can be anywhere on the system.
the LDF and MDF files are inside the BAK file
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24145710
moreover, where did you create Alumni database before restore? give the same path
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

Suggested Solutions

Title # Comments Views Activity
Help Required 2 32
export sql results to csv 6 35
Need a SQL query that creates a header row and one or more detail rows. 7 31
Deal with apostrophe in stored procedures 8 42
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

776 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