Solved

Can mdf and ldf files be attached to SQL Server in another system

Posted on 2009-05-20
4
527 Views
Last Modified: 2012-05-07
We received some client mdf and ldf files.  They are on their own different SQL Server installation.  Is there any way to attach these files to our SQL Server.  It obviously will not be listed in Master.  They have either SQL Server 2000 or 2005, I forget which.  We have both versions available.

Thanks for your help
0
Comment
Question by:gkravitz10
4 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 50 total points
ID: 24433167
right click on the database on EM or SSMS, select 'attach', browse and add the files .
If you try to attach a 2005 db to the 2000 server, you will get an error.
0
 
LVL 17

Assisted Solution

by:Shanmuga Sundaram
Shanmuga Sundaram earned 40 total points
ID: 24433244
Yes as aneeshattingal said, we can attach database of same versions. Also we can attach the db from old version (2000) in new version (2005). But using new version db in oldversion is tedious. This link will help you.

http://www.c-sharpcorner.com/UploadFile/raj1979/AttachDatabase08252008061546AM/AttachDatabase.aspx
0
 
LVL 21

Accepted Solution

by:
Tapan Pattanaik earned 390 total points
ID: 24433262
hi gkravitz10,

                     check these links, your solution is here.

How to: Attach a Database (SQL Server Management Studio):

http://msdn.microsoft.com/en-us/library/ms190209.aspx

How to attach a database in SQL Server 2005:

http://www.c-sharpcorner.com/UploadFile/raj1979/AttachDatabase08252008061546AM/AttachDatabase.aspx

SQL Server 2005: How to Attach (or Reattach) a Database Missing the LDF:

http://www.tech-recipes.com/rx/1867/sql_server_2005_how_to_attach_or_reattach_a_database_missing_the_ldf/

      

Attaching and Detaching Databases:

http://www.mssqlcity.com/Articles/Adm/attach_database.htm

MS SQL Server 2008 Attach Database .MDF File:

http://www.kodyaz.com/articles/sql-server-attach-database-mdf-file.aspx

0
 
LVL 13

Assisted Solution

by:St3veMax
St3veMax earned 20 total points
ID: 24433472
Please bear in mind that if they are SQL 2000 Databases and you import them into SQL 2005 and you need to send them back; they cannot work again with SQL2000 as they have been upgraded.

Hope this helps.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

708 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