I have been trying to import Raster data into an ArcSDE 9.3 FGB in MSSQL Server. Due to unknown factors (but probably due to the size of the data and network) this has failed now on 3 occasions leaving me with massive datasets which are corrupt. We are talking about 4 Datasets of around 200gb Each. On the last occasion, I wasn´t aware that the MSSQL Transactional log would grow to the same size as the file I was trying to import (270GB) and had to cancel the copy operation in ArcCatalog due to the hard drive being full.
So now I have massive databases full of corrupt data. I am looking for a solution on how to delete the corrupt files out of the sde databases without corrupting the whole database. ArcCatalog give the error "cannot delete raster" when I try to delete it...so I need to do it from MSSQL Server.
Could anyone tell me how to remove these file from arcsde 9.3?
Its extremely difficult to give specific advice without a lot more details. Normally this would be something Tech Support could help with, but ArcGIS 9.3 moved to "Retired" support status with the new year. You should still make the request, though.
Given your description of the state of your database, you might find it easier to copy out the vector data into a new database (at the same release level of your ArcGIS Desktop -- 10.0sp5 or higher), then make another database as a transition space to copy the undamaged rasters, then detach the old database and toss the datafiles on a USB drive (just in case).
Once your instance is stable, then you'll have some time to research transition to modern file-based raster management techniques with ArcGIS 10.x.
I have deleted a raster dataset in ArcCatalog (simply by right clicking and choosing delete). The data is stored in an ArcSDE geodatabase on an SQL Server. However, the dataset continues to appear/remain visible in the table of contents in ArcCatalog. Even though its disfunctional/ well actually deleted. How can I remove it completely?