Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Los Angeles
    Posts
    6

    Question Unanswered: SQL 2K Unallocated Space Won't Free Up - HELP!

    I've gone through the forum and have seen several others with a similar situation. I recently noticed my .mdf file grew to 200GB yet the data in the file is only about 40GB. I run sp_spaceused and get the following: database_size = 176GB, unallocated space = 134GB, reserved = 43GB, data = 17GB, index_size = 19GB, unused = 6GB.

    I've tried "dbcc shrinkdatabase (mydb, truncateonly)", tried restarting server, tried running a maintenance plan including a reindex of the database, and I don't know what to do next.

    Does anyone know how to free up this space?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You JUST noticed it? Do shrinkfile on it.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jul 2003
    Location
    Los Angeles
    Posts
    6
    Thanks. I tried another's suggestion and ran shrinkdatabase (mydb, 1) which ran for 5 hours and then deadlocked - as the victim. However, then I tried shrinkdatabase again straight from the Enterprise Mgr interface and it worked this time. Thanks for the suggestion anyway.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •