Diadem Technologies Hosting Knowledgebase

Delete MSSQL Server DB from SQL Management Studio

Article ID: 1234
Last updated: 26 Jul, 2020

 How to Delete a SQL Server DB from management studio

Before we begin we must know about Limitations and Restrictions while deleting a database from SQl server DB.

  • System databases cannot be deleted.

Prerequisites

  • Delete any DB snapshots that exist on the database.

  • If the database is involved in log shipping, remove log shipping.

  • If the database is published for transactional replication, or published or subscribed to merge replication, remove replication from the database.

Permissions

  • To execute DROP DB, at a minimum, a user must have CONTROL permission on the database.

Using SQL Server Management Studio

To delete a database

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand Databases, right-click the database to delete, and then click Delete.

  1. Confirm the correct database is selected, and then click OK.

Refresh your server and CMDB database will not be displayed under database.

Using Transact-SQL

To delete a database

  1. Connect to the Database Engine.

  2. From the Standard bar, click New Query.

  1. Type the script into the query window and click Execute.

After refreshing your server CMDB database will no longer will be the part part pf the database server.

This article was:  
Report an issue
Article ID: 1234
Last updated: 26 Jul, 2020
Revision: 14
Views: 13
Comments: 0