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

3245
3
Jump to solution
06-16-2015 12:08 PM
DavidWheelock
Occasional Contributor III

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?

0 Kudos
1 Solution

Accepted Solutions
George_Thompson
Esri Frequent Contributor

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

GeodatabaseEnterprise GIS

--- George T.

View solution in original post

3 Replies
George_Thompson
Esri Frequent Contributor

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

GeodatabaseEnterprise GIS

--- George T.
QuinnFrancis
New Contributor III

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)

DavidWheelock
Occasional Contributor III

Thanks!  I thought that might be it.

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

0 Kudos