Open Microsoft SQL Server. Select an instance of the SQL Server Database Engine from the SQL Server Management Studio Object Explorer. Select “Connect” to connect to the instance. Right-click “Databases.” Click “Attach” and click “Add.” Browse to the location of your MDF database. Double-click the database file to open it inside SQL Server and view stored data. You cannot open an MDF database in a new instance if it is already attached to an existing instance. Writer Bio
