Post reply

Deleted files not freeing up space

  • January 16, 2009 at 9:44 am

    #205117

    We are using ARCGIS. It has an SDE interface between SQL and GIS. Our GIS Analyst deleted 80+G through SDE but it didn't free up the space on the drive. Any ideas?

    Marcelene

  • January 16, 2009 at 10:02 am

    #928308

    I'm not familiar with your application, but here's a best guess: if the "files" deleted are really tables in SQL, the space isn't released unless you shrink the database.

    can you go to the database in sQL server management studio...right click for properties, and look at Size and Space Available...you might have 80Gig available, so you could shrink the db if you wanted.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 16, 2009 at 10:57 am

    #928356

    A shrink was done on the 14th successfully but it didn't free up space. They were files in the ‘imagery’ database, not a database. They were in a special kind of container called a raster catalog, but they were not a separate SQL database, they were within the existing ‘imagery’ db. Our GIS Analyst is going to a GIS meeting this afternoon where he hopes someone there will be able to help, also.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply