• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

I need to attach an unknown pair (.MDF/.LDF) files to SQL Server. I am not familiar with SQL at all. Please give step-by-step instructions, from opening the Enterprise Manager or Query Analyzer

I have read many similar answers to similar questions, but I am so new to SQL that I don't understand the solution, because I don't know where to start from. I know I need to enter some commands, but I don't know how. Please talk me through the entire sequence from opening the Enterprise Manager, each and every option to choose to reach the result of attaching these 2 files to a new database. Then I will want to export this information to an Access database. By the way, I have SQL Server 7 teporarily installed on my desktop computer. I will not need to continue using this database, I only need to view & export the contents.

Thank you,
CombsKC
0
CombsKC64
Asked:
CombsKC64
  • 10
  • 10
1 Solution
 
Gautham JanardhanCommented:
1) WHers ur .mdf and .LDF file
2) what do u mean by sayin unknown pair of (.mdf/.LDF) ?
3) Open EM
4) rt click Database --> all tasks -->Attach DB. Give the path of the .mdf file
5) attach as (which name u wanna c the DB)
6) Specify the owner and click OK
0
 
Gautham JanardhanCommented:
After Opening EM, do u have ur server registered.
if not register ur DB server first

1)Rt click on the tree left side and click new server registration, that wizard will take u thru the registration process.

once its registered, u will c the server in the tree

expand server and u will c databases.

from there follow steps 4 onwards in the previous post..

0
 
CombsKC64Author Commented:
1) .mdf and .ldf files are on a local hard drive partition, but were copied from another server.
2) unknown meaning, they are not recognized by the server.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
CombsKC64Author Commented:
I have a list of databases in my server tree. I am assuming that it is already registered, correct? Otherwise, how do I know if my server is registered?

When I right click on databases/All Tasks/, there is no option to "attach DB". Only "backup. Restore, Import, Export".
0
 
Gautham JanardhanCommented:
<<
I have a list of databases in my server tree. I am assuming that it is already registered, correct? Otherwise, how do I know if my server is registered?


Yes its already registered and the databases in the server are shown there.
0
 
Gautham JanardhanCommented:
the server registered -- is it ur local server ?

if not register ur local server
0
 
CombsKC64Author Commented:
it is the only server. it is on my desktop computer. I only installed it so I could access the information in these .mdf & .ldf files, and then export that information to access.
0
 
Gautham JanardhanCommented:
k.. now
rt click Database --> all tasks -->Attach DB. Give the path of the .mdf file
 attach as (which name u wanna c the DB)
 Specify the owner and click OK

afetr this ur database will be listed along with other databases
0
 
CombsKC64Author Commented:
When I right click on databases-->All Tasks-->, there is NO option to "attach DB". Only "Backup. Restore, Import, Export".
Is there something wrong?
0
 
Gautham JanardhanCommented:
whic is the version of sql server u r using?
0
 
CombsKC64Author Commented:
Does it make a difference if I have the "desktop" version or "full" version?
0
 
CombsKC64Author Commented:
I am currently using the desktop version. I will try to install the full version if that will solve the problem.
0
 
Gautham JanardhanCommented:
take a look at this link

http://support.microsoft.com/kb/208888
0
 
CombsKC64Author Commented:
OK, so I have attached the files to a database. Now I need to export the information to MS Access. I go through the export instructions until I get to the "tables to transfer", then it is blank, and there is not active buttons. What do I do to automatically sellect the tables in the database?
0
 
CombsKC64Author Commented:
Oh sorry, there are no tables in the database. How can I verify that the database has been attached properly?
0
 
Gautham JanardhanCommented:
Import and Export data (copy objects and data between SQL Server databases)
You can copy a whole database or selectively copy objects and data from the source database to the destination database by using the Data Transformation Services Import and Export Data Wizard.• The source database may be used during the transfer. If the source database is used during the transfer, you may see some blocking when the transfer is in progress.
• When you use the Import and Export Data Wizard, the character set, sort order and collation does not have to be the same between the source server and destination server.
• Because unused space in the source database does not move, the destination database may not have to be as large as the source database. Similarly, if you move only some objects, the destination database may not have to be as large as the source database.
• SQL Server 7.0 Data Transformation Services may not transfer text and image data longer than 64 KB correctly. This problem does not apply to the SQL Server 2000 version of Data Transformation Services.
0
 
Gautham JanardhanCommented:
To use the DTS Wizard to transfer your data you can use these steps:

1.
 In SQL Server Enterprise Manager, on the Tools menu, point to Data Transformation Services, and then click Export Data.
 
2.
 In the Choose a Data Source dialog box, select Source,
 
3. In the Choose a Destination dialog box, select Destination
4.
 In the Specify Table Copy or Query dialog box, click Copy tables.
 
5.
 In the Select Source Tables dialog box, click Select All.
 
0
 
CombsKC64Author Commented:
How can I verify that the database has been attached properly?
0
 
Gautham JanardhanCommented:
<< Oh sorry, there are no tables in the database. How can I verify that the database has been attached properly

what does it mean?

did u create a new db

How did u attach the db ?
0
 
CombsKC64Author Commented:
I attached the DB according to the website you gave me above. Then try to export using the DTS wizard.
How can I verify that the files were attached to the database properly?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 10
  • 10
Tackle projects and never again get stuck behind a technical roadblock.
Join Now