Click here to Skip to main content
11,642,216 members (61,763 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
Dear Sir,

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


regards
sashi
Posted 30-Dec-11 20:21pm
Rate this: bad
good
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 :
http://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/[^]


Hope it helps.
  Permalink  
Comments
Mika Wendelius at 31-Dec-11 6:15am
   
Good answer, 5.
Amir Mahfoozi at 31-Dec-11 6:21am
   
Thanks Mika :)
Rate this: bad
good
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.
  Permalink  
v2
Rate this: bad
good
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: http://www.connectionstrings.com/sql-server-2008[^] and example Attach a database file on connect to a local SQL Server Express instance
  Permalink  
Comments
Amir Mahfoozi at 31-Dec-11 5:13am
   
+5 There was very useful information on that page.
Mika Wendelius at 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
0 DamithSL 240
1 Sergey Alexandrovich Kryukov 184
2 Afzaal Ahmad Zeeshan 139
3 OriginalGriff 135
4 Mika Wendelius 80
0 Mika Wendelius 460
1 DamithSL 443
2 OriginalGriff 340
3 Afzaal Ahmad Zeeshan 228
4 Sergey Alexandrovich Kryukov 179


Advertise | Privacy | Mobile
Web02 | 2.8.150731.1 | Last Updated 31 Dec 2011
Copyright © CodeProject, 1999-2015
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