Click here to Skip to main content
13,149,756 members (63,629 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Dear Sir,

I have dowloaded only a .mdf file.Kindly help me how can i add it into the Sql Server database ?

Posted 30-Dec-11 20:21pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

However you will not have the transaction log after attaching to a mdf file without its log file, consider this solution :
Run this query in SSMS
EXEC sp_attach_single_file_db @dbname='DBName', @physname=N'c:\data\db_data.mdf'

And then refresh you Database section an you will see it.

For more information read here :[^]

Hope it helps.
Mika Wendelius 31-Dec-11 6:15am
Good answer, 5.
Amir Mahfoozi 31-Dec-11 6:21am
Thanks Mika :)
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

paste your file inside data folder in mssqlserver.

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

then open sqlserver. In the object explorer RightClick on database and select attach.

browse , select the database to attach and click attach. this will do the trick for you.
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

And if you're using SQL Server Express Edition you can also attach the mdf to the SQL Server instance by connection string, see:[^] and example Attach a database file on connect to a local SQL Server Express instance
Amir Mahfoozi 31-Dec-11 5:13am
+5 There was very useful information on that page.
Mika Wendelius 31-Dec-11 6:15am
Thanks :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170924.2 | Last Updated 31 Dec 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100