How to delete mutiple database from sql management studio

At times you might have come across deleting multiple databases. One of the scenarios may be Sitecore creating many DB’s and if it is sitting stale doing nothing you might want to delete those DB’s. You might first try to run the uninstall script to get the site and all related db’s deleted, but if you are deleting this manually you might wonder how to delete mutiple or all db’s in sql server on dev machine in one go.

  1. Open the SQL server management studio
  2. Press F7 or select View in menu and open Object Explorer Details.
  3. Click on Database folder in Object Explorer all db’s will be listed
  4. Select DB’s of your choice to delete. Right click on selected DB’s
  5. Choose option Close existing connections and Click OK
  6. Selected DB’s will be deleted

 

sc902error4

sc902error5

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s