Click the name of your SQL server in the Object Explorer pane to expose your databases. Select "user databases," then right-click the name of the database you want to restore (Source 1).

Once you disconnect a database, you must restore it from its .MDF file in a process called "attachment." SQL Server offers two ways to attach the .MDF file: via the Management Studio program's ...