Click here to Skip to main content
15,867,888 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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

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
SQL
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.
 
Share this answer
 
Comments
Wendelius 31-Dec-11 6:15am    
Good answer, 5.
Amir Mahfoozi 31-Dec-11 6:21am    
Thanks Mika :)
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.
 
Share this answer
 
v2
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
 
Share this answer
 
Comments
Amir Mahfoozi 31-Dec-11 5:13am    
+5 There was very useful information on that page.
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)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900