Thursday, April 14, 2016

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

Leave a Reply

Subscribe to Posts | Subscribe to Comments

- Copyright © Ady Purnama -Metrominimalist- Designed by djogzs -