Renamed/Recreate Mosaic Dataset

[CynthiaMatney]

I apparently have done something you are not supposed to do. I renamed a mosaic dataset  w/in my sde - now the sde doesn't show either the renamed mosaic (Aerials2010_old) nor the old mosaic (Aerials2010). 

So, I thought I'd recreate the mosaic and call it the original name - but when I go to create the mosaic dataset it tells me that the table already exisits [Microsoft SQL Server Native Client 10.0: There is already an object named 'AMD_AERIALS2010_CAT' in the database].

Any ideas?

Thanks!

[MelanieHarlow]

It unfortunately looks like your mosaic dataset got corrupted. This particular issue has appeared before, but should have been fixed in the service packs.
Unfortunately, there's no fix for your original mosaic dataset. I would delete any of those AMD_* items, get the latest service pack, and recreate your mosaic dataset with a new name.

[CynthiaMatney]

That is what I was afraid of - I actually went ahead and recreated the mosaic dataset.  However, I am not sure how to delete the AMD items as I cannot see them w/in the sde.

[HongXu]

Yes when data is corrupted, some tables will be left in the geodatabase which ArcCatalog won't be able to see. There is a workaround (a registery key setting) which allows you to see the tables and delete them. Please contact Esri technical support to get the detail steps.

Hong

[ChadRiley]

Hello, we have the same problem, can we just delete the AMD_* tables using SQL Management Tools?  Do we need to delete any records out of the SDE_layers table, or any other tables in SDE?

Thanks,
Chad