Detach and attach database in Microsoft SQL Server Management Studio

This video demonstrates how to detach a database in Microsoft SQL Server Management Studio, locate the database files on the computer, and re-attach the database back in Microsoft SQL Server Management Studio.
Occasionally if you see an error detaching the database then just close Management Studio and re-open would solve the problem, if not try to restart your SQL Server through Configuration Manager or reboot the computer.