Ady Purnama: Detach/Delete Unused SQL Server Database

Sometime database need to be deleted or detached. The basic different between this options are:

Detach
The selected database has been dropped from sql server list. Which mean all process can't be done again, such as: select, insert, delete, update, backup, etc.
But the physical file still available on server. Hence, if needed it can be Attach easily.
Delete
The selected database has been dropped from sql server list. Which mean all process can't be done again, such as: select, insert, delete, update, backup, etc.
But the physical file has been deleted from server. Hence, the Attach process can not be done directly. The restore process should be done to reactivate the database.

Here are step by step to delete the database on SQL Server 2008

Ady Purnama