Home > IT Answers > SQL Server > Attaching MDF and LDF files to SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Attaching MDF and LDF files to SQL Server 2005
LDF, MDF, SQL Server 2005
I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2005?

Software/Hardware used:
ASKED: February 27, 2009  3:33 PM
UPDATED: May 20, 2011  1:50 AM
RELATED QUESTIONS
Answer Wiki:
Where the MDF and LDF detached from the SQL Server at the same time, if they were then you can attach them using the sp_Attach_db system stored procedure. However if they were detached at two different times they there are useless together. You can attach the MDF file without the LDF File by using the sp_attach_single_file_db system stored procedure. This procedure will attach the database and create a new log file.
Last Wiki Answer Submitted:  February 27, 2009  7:14 pm  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

i have different problem ..i m having server 2008 at my office but server 2005 at my place..when i try to attach mdf file of server 2008 to server 2005 it doesnt allow..

is it possible to attach mdf file to the lower version or..:(

Hhhh
 10 pts.
 

No you can not attach a database from a newer edition to an older edition. You will need to purchase the developer edition for your home computer ($50 US) or get the trial edition of SQL Server 2008.

Denny Cherry
 64,505 pts.
 

can i attach an mdf and ldf file which was created in sql server 2000 to sql server 2005 enterprise edition?if so please explain me in steps?thanks in advance

Itdonsavi
 30 pts.
 

Yes, you can always go up, but once you attach to a newer version you will not be able to attach that same database to an older version.

In SQL Management Studio, connect the object explorer to the server, then right click on databases, select all tasks, then attach database. Select the mdf file of the database you wish to attach and then click ok. The database will then be attached to the SQL 2005 instance.

Denny Cherry
 64,505 pts.
 

i am currently working on a migration db. i have backup the mdf. and ldf. and same time i have export and import the database to the new server. do i still need to work on the mdf as mention?

Marllee
 10 pts.