To detach your local database from within your Management Studio Open SQL Management Studio and go to the Object Explorer Expand the database node Right click on the database you want to detach Select Tasks -> Detach