topic How do I delete an enterprise geodatabase from an instance in SQL Server? in Data Management Questions

How do I delete an enterprise geodatabase from an instance in SQL Server?

DavidWheelock — Tue, 16 Jun 2015 19:08:43 GMT

I have an ArcGIS 10.3.1 enterprise geodatabase in a new MS SQL Server instance that I just migrated from 9.3.1. There are several live geodatabases in this instance. I created a new, empty "test" geodatabase to try out the new "Create Enterprise Geodatabase" tool in ArcToolbox. So, that worked, and now the new test geodatabase is taking up about half a GB of space and I would like to delete it. However, ArcToolbox does NOT contain a "Delete Enterprise Geodatabase" tool or anything else that might be helpful in deleting the geodatabase in question.

I looked in the ArcGIS online help and can find nothing there about how to delete an enterprise geodatabase, either.

How do I delete an enterprise geodatabase from an instance in SQL Server?

Re: How do I delete an enterprise geodatabase from an instance in SQL Server?

George_Thompson — Tue, 16 Jun 2015 19:18:44 GMT

Hi David,

You would just delete the database in SQL Server Management Studio.

There is no "out of the box" tool to delete enterprise geodatabases.

-George

Geodatabase Enterprise GIS

Re: How do I delete an enterprise geodatabase from an instance in SQL Server?

QuinnFrancis — Tue, 16 Jun 2015 19:19:09 GMT

Hi David,

You'll need to delete the database on the RDBMS side (SQL Server). DROP DATABASE should do the trick.

DROP DATABASE databaseName;

DROP DATABASE (Transact-SQL)

Re: How do I delete an enterprise geodatabase from an instance in SQL Server?

DavidWheelock — Tue, 16 Jun 2015 19:26:08 GMT

Thanks! I thought that might be it.

Still, it would be helpful if ESRI would put a tool for that in ArcToolbox.