Post reply

having doubt in output of dbcc shrinkdatabse command

  • February 28, 2013 at 12:23 pm

    #271731

    Hi on executing dbcc shrinkdatabase we get following as result

    a>DbId, b>FileId, c>CurrentSize, d>MinimumSize e>EstimatedPages

    except for first id didn`t get rest all

    first database can have many file and when execute shrinkdatabase then does sql server tries to shrink all files aor only one

    second why option c,d,e are expressed in number of 8 kb pages , are this outputs mere number or they are sizes in gb/md/kb and in order to get actual size we have to do some maths to decode it .

    Please clear my doubts

  • February 28, 2013 at 6:23 pm

    #1592216

    Before doing anything like that, know what you're getting into. Read this: [/url]

    Gail explains in detail why this is a bad idea, and the one or two instances when it could be okay to do it.

  • March 1, 2013 at 4:48 am

    #1592315

    Agreed, shrinks should definitely be avoided except in certain circumstances.

    In answer to you questions:

    Shrinkdatabase attempts to shrink all files, but only returns data for those that were actually shrunk.

    Values are number of 8KB pages. So multiply by 8 or divide by 128 to get KB/MB respectively.

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

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