Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2009
    Posts
    18

    Unanswered: Shrinking of database

    Hello, when shrinking a data file i get the below but the file does not shrink does this mean that there is not enough space to shrink the file or what does it mean?

    dbid fileid CurrentSize MinSize UsedPages EstimatedPages
    7 1 8481288 96 8466512 8466512

    Thanks
    Last edited by f3494152; 06-23-09 at 10:10.

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    What below ?

  3. #3
    Join Date
    Feb 2009
    Posts
    18
    Sorry, i will attach the message shortly. Thanks

  4. #4
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Do you show any "space Available" in the DB properties tab (outside the size of the .ldf file)?

    Are you sure that it is not all Tlog space (.ldf) that reflects your space available for the database ?

  5. #5
    Join Date
    Jun 2009
    Posts
    26
    If you are trying to shrink your transaction log (.ldf) you will need to do a transaction log backup first - then shrink.

    Also because of the way the pages may be ordered you may need to backup the transaction log and shrink the log file a few times for this to have a major impact.

  6. #6
    Join Date
    Feb 2009
    Posts
    18
    hi, i am trying to shrink the data file (mdf). The db properties tab shows that there is 0mb free space.

  7. #7
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Quote Originally Posted by f3494152
    hi, i am trying to shrink the data file (mdf). The db properties tab shows that there is 0mb free space.
    It looks like it's been shrunk as far as it can go. 0MB free is never a good thing. Are you sure you don't mean you want it grow? If you did shrink the .mdf, be sure to rebuild your indexes because you've rendered them potentially useless.

Posting Permissions

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