Results 1 to 5 of 5

Thread: Production Database - Unallocated space issue

  1. 04-08-2009, 11:07 AM #1
    mariposa.azul
    mariposa.azul is offline Registered User
    Join Date
    Jan 2009
    Posts
    22

    Production Database - Unallocated space issue

    I have a Production database that has 103774.13MB of unallocated space. The database size is 101GB.
    How can I free up database space in order to bring the db data file down on size?

    I have rebuild index, I have shrinked log files, I have Reorganized the Indexes.

    Please let me know. Thank you!
    Reply With Quote Reply With Quote
  2. 04-08-2009, 12:49 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You need shrink data file.
    Reply With Quote Reply With Quote
  3. 04-08-2009, 02:48 PM #3
    mariposa.azul
    mariposa.azul is offline Registered User
    Join Date
    Jan 2009
    Posts
    22
    What happens if I shrink the database?
    Shrinking the data file did not help much.
    Reply With Quote Reply With Quote
  4. 04-09-2009, 08:22 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Shrinking db just shrinks all files in the db.
    Reply With Quote Reply With Quote
  5. 04-09-2009, 10:38 AM #5
    mariposa.azul
    mariposa.azul is offline Registered User
    Join Date
    Jan 2009
    Posts
    22
    thank you very much for your help. It worked.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules