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

2815
3
Jump to solution
06-16-2015 12:08 PM
Highlighted
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?

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
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
Highlighted
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

Highlighted
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)

Highlighted
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.

Reply
0 Kudos