How to create DB back from .mdf and .ldf (data and log file)?

Question

Is that restore or some other process? forgot

Answer 1

You need to attach the .mdf file.

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

---

Mangal Pardeshi
SQL With Mangal

Answer 2

Hi
By Running the below query we can attach the database (Considering two files .mdf and .ldf files)

EXEC 

sp_attach_db @dbname = N'DatabaseName',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DatabaseName_Data.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DatabaseName_log.ldf'

The path what i have given is default path. It changes based upon where the .mdf and .ldf files are Placed.
After attaching(Restoring) the Database. We can take Backup from that

Thanks
Ramesh.M

Answer 3

my mdf file is stored in

c:\\db\db.mdf

i want to attach db and keep it here...

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

how to do?

Answer 4

Is this .mdf Associated Database already there in the SQL Server?
Or
We have to create Database by using this .mdf File? Can you please clarify me

Thanks
Ramesh.M

Answer 5

my mdf file is stored in

c:\\db\db.mdf

i want to attach db and keep it here...

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

how to do?

Copy the mdf and ldf files to the directory listed above then attach the database file to your SQL server. 
http://msdn.microsoft.com/en-us/library/ms190794.aspx