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 ...

Once it’s there go back into SQL Server Management Studio. Right-Click the databases Folder, The click Attach. Locate the new location of your database, then select the database and click OK.