Creating new database with existing MDF(only MDF) file.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  October 22, 2008 at 11:37 pm

  #194941

  Dear All,

  I have downloaded MDF of my database from live server to local server.

  Now I want to create a database in loocal server pointing to this MDF file.

  How can I do it..?

  Thanks in advance.

  Santhu.

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  October 22, 2008 at 11:43 pm

  #888467

  nairsanthu1977 (10/22/2008)

  ---

  Dear All,

  I have downloaded MDF of my database from live server to local server.

  Now I want to create a database in loocal server pointing to this MDF file.

  How can I do it..?

  Thanks in advance.

  Santhu.

  Attach that MDF

  USE [master]

  GO

  CREATE DATABASE [database_name] ON

  ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\ .mdf' ),

  ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\ .ldf' )

  FOR ATTACH ;

  GO

  in case if you dont have the /ldf file : use this

  EXEC sp_attach_single_file_db @dbname = 'pubs',

  @physname = 'C:\MSSQL\Data\pubs.mdf'

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com

• duncanlarry

  SSC Veteran

  Points: 270

  More actions

  April 19, 2013 at 9:30 am

  #1608287

  Good Post.

  I forgot how to create a database from the .mdf and .ldf file but this reminded me.

  Thanks

• SQListic

  SSCertifiable

  Points: 6904

  More actions

  September 29, 2014 at 10:01 am

  #1748868

  Restoring Orphaned MDF File in SQL Server

  http://www.sqlserverbox.com/restoring-orphaned-mdf-file-in-sql-server.html

  http://sqlism.blogspot.com/2014/09/restoring-orphaned-mdf-file-in-sql.html