topic Re: Can't delete a geodatabase a00002.gdbtable in Data Management Questions

Can't delete a geodatabase a00002.gdbtable

TomMagdaleno — Fri, 02 Aug 2013 14:17:06 GMT

My workflow the last few years is to have an editing copy and a user copy of my file geodatabases. Roughly once a month I wait until everyone is out of the user geodatabase and all lock files are gone so I can delete and overwrite it with the editing copy. Lately I have been having a problem where even though no one is using the geodatabase it says I cannot delete a00002.gdbtable. When I open the geodatabase in windows explorer all I see are a bunch of .gdbtable files that will not delete. It says they are in use, but everyone it out and their are no lock files. The only way I can update the geodatabase is to copy and paste in windows explorer everything out of the editing copy of the file into the user copy of the file. What is going on?

Re: Can't delete a geodatabase a00002.gdbtable

JakeSkinner — Fri, 02 Aug 2013 17:47:04 GMT

Hi Tom,

ArcSDE for SQL Server Express is included free as part of ArcGIS for Desktop Standard and Advanced. I would recommend using an SDE geodatabase to perform your edits, and then you can set up geodatabase replication to replicate the changes to the File Geodatabase.

Re: Can't delete a geodatabase a00002.gdbtable

TomMagdaleno — Fri, 02 Aug 2013 20:39:59 GMT

I'm trying to do that and every time I get an error 00582 every time I try to create a replica.

Re: Can't delete a geodatabase a00002.gdbtable

JakeSkinner — Tue, 06 Aug 2013 09:46:21 GMT

Are you using the GP tools to create the replica? Try using the 'Create Replica' tool on the Distributed Geodatabase toolbar and see if you receive the same error.

Re: Can't delete a geodatabase a00002.gdbtable

TomMagdaleno — Wed, 07 Aug 2013 14:01:44 GMT

Are you using the GP tools to create the replica? Try using the 'Create Replica' tool on the Distributed Geodatabase toolbar and see if you receive the same error.

I am using the correct tool. I'm still getting that weird error.

Re: Can't delete a geodatabase a00002.gdbtable

WilliamCraft — Fri, 13 Sep 2013 01:37:11 GMT

I think these might be 'open files' despite no longer have a .lock file. Are you using Windows 2008 R2 by chance? If so, open the Start menu and type fsmgmt.msc and hit enter. Click on Open Files, find your GDB files in the list, select them all with Shift+click, and right-click to close.

Re: Can't delete a geodatabase a00002.gdbtable

TomMagdaleno — Fri, 13 Sep 2013 13:41:12 GMT

William, that is brilliant. I didn't know about that trick. The problem comes and goes, now I have a way of making it go.