SQL Server Importing database from mdf

Question

I have an  mdf file on my local box   I have SQL Server 2008 Express and SQL Management Studio 2008 Express installed on my local box   How in the world do I import this  mdf file as a new database into my SQL Server   This seems like a ridiculously common task that must be performed thousands of times a day across the globe  and I cannot figure out how to do it in Management Studio Express   What am I missing

User · Answer

Open SQL Management Studio Express and log in to the server to which you want to attach the database  In the  Object Explorer  window  right-click on the  Databases  folder and select  Attach     The  Attach Databases  window will open  inside that window click  Add     and then navigate to your  MDF file and click  OK   Click  OK  once more to finish attaching the database and you are done  The database should be available for use  best regards

User · Answer

Apart from steps mentioned in posted answers by  daniele3004 above  I had to open SSMS as Administrator otherwise it was showing Primary file is read only error   Go to Start Menu   navigate to SSMS link   right click on the SSMS link   select Run As Administrator  Then perform the above steps

User · Answer

If you do not have an LDF file then    1  put the MDF in the C  Program Files Microsoft SQL Server MSSQL13 SQLEXPRESS MSSQL DATA   2  In ssms  go to Databases - gt  Attach and add the MDF file  It will not let you add it this way but it will tell you the database name contained within   3  Make sure the user you are running ssms exe as has acccess to this MDF file   4  Now that you know the DbName  run  EXEC sp attach single file db  dbname    DbName     physname   N C  Program Files Microsoft SQL Server MSSQL13 SQLEXPRESS MSSQL DATA yourfile mdf     Reference  https   dba stackexchange com questions 12089 attaching-mdf-without-ldf

User · Answer

To perform this operation see the next images     and next step is add   mdf file   very important  the  mdf file must be located in C        MSSQL12 SQLEXPRESS MSSQL DATA    Now remove the log file

User · Answer

See  How to  Attach a Database File to SQL Server Express  Login to the database via sqlcmd   sqlcmd -S Server Instance   And then issue the commands   USE  master  GO CREATE DATABASE  database name  ON    FILENAME   N C  Program Files Microsoft SQL Server MSSQL11 MSSQLSERVER MSSQL Data  lt database name gt  mdf       FILENAME   N C  Program Files Microsoft SQL Server MSSQL11 MSSQLSERVER MSSQL Data  lt database name gt  ldf     FOR ATTACH   GO

[sql-server] SQL Server: Importing database from .mdf?

Examples related to sql-server

Examples related to database

Examples related to import

Examples related to mdf

Examples related to ssms