SQL Server: Importing database from .mdf?

by

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 🙂

Related Contents:

  1. Import / Export database with SQL Server Server Management Studio
  2. How to change default database in SQL Server without using MS SQL Server Management Studio?
  3. How to install SQL Server Management Studio 2012 (SSMS) Express?
  4. How to connect to a local database in SQL Server Management Studio?
  5. Why is “close existing connections to destination database” grayed out on SQL Server 2012 Management Studio?
  6. Multiple Indexes vs Multi-Column Indexes
  7. How do you specify a different port number in SQL Management Studio?
  8. How to do version control for SQL Server database?
  9. Unique constraint on multiple columns
  10. SQL Server. How to refresh the intellisense? [duplicate]
  11. SQL Server Management Studio, how to get execution time down to milliseconds
  12. How to drop all tables in a SQL Server database?
  13. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  14. How to alter SQL in “Edit Top 200 Rows” in SSMS 2008
  15. Generate table relationship diagram from existing schema (SQL Server) [closed]
  16. The backend version is not supported to design database diagrams or tables
  17. SQL Server Management Studio won’t let me add an index to a table
  18. What columns generally make good indexes?
  19. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  20. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  21. How to view the stored procedure code in SQL Server Management Studio
  22. mssql ‘5 (Access is denied.)’ error during restoring database
  23. Is it safe to have SQL Server auto-shrink turned on?
  24. How to duplicate MSSQL database on the same or another server?
  25. Timeout saving table in SQL Server
  26. SQL Server – Force DB in memory?
  27. Is there a secure way to allow IIS 7 in a DMZ to access a DB server behind the firewall?
  28. Preferred Method of Storing Passwords In Database
  29. In sql server 2005, how do I change the “schema” of a table without losing any data?
  30. SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?
  31. Naming of boolean column in database table [closed]
  32. Stored procedures/DB schema in source control
  33. In SQL Server Management Studio what is SQLCMD mode?
  34. What is the T-SQL syntax to connect to another SQL Server?
  35. Logging ALL Queries on a SQL Server 2008 Express Database?
  36. How to fix a collation conflict in a SQL Server query?
  37. Create a view with ORDER BY clause
  38. Error Invalid prefix or suffix characters in SQL Server Management Studio
  39. What do these Copy Only Backup options mean?
  40. How do I shrink my SQL Server Database?
  41. Find a string by searching all stored procs in SQL Server Management Studio 2008
  42. How to generate scripts to recreate table using SQL Server Management Studio [Schema and data]?
  43. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  44. The request failed or the service did not respond in a timely fashion?
  45. Database name convention: DATETIME column
  46. How can I display the execution plan for a stored procedure?
  47. Query times out when executed from web, but super-fast when executed from SSMS
  48. Limit SQL Server column to a list of possible values
  49. Database that can handle >500 millions rows
  50. Script all stored procedures in Management Studio 2005

Leave a Comment