Post reply

Alternatives to Shrink Database

  • June 24, 2011 at 2:53 am

    #243266

    Hi all,

    I am well aware about not shrinking databases - but I wonder if anyone can suggest an alernative method to reduce the size of a database when the data file has virtually taken up all the disk space allocated. I have only just joined the company so was not involved in planning the disk space on this server. I have requested more space but I have been told that this will not be granted and other solutions need to be found.

    Thanks,

    George

  • June 24, 2011 at 2:57 am

    #1343545

    Alter the database and point the file to another drive (or) Add new drive.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • June 24, 2011 at 3:05 am

    #1343550

    Do you want to elaborate on that Muthukkumaran?

    George, what percentage of the database is in use? If there's no extra storage available and you must do it, you may have to shrink it. If you rebuild all indexes afterwards, this will minimise the impact in terms of fragmentation.Sometimes this is a legitimate action if the database has grown massively beyond it's likely future size through an abnormal operation.

    If, say, only 10-20% is free though, I'd press the issue for more storage or archiving now - otherwise there'll be nothing you can do when it does grow beyond your storage capacity.

  • June 24, 2011 at 3:49 am

    #1343564

    Thanks Howard.

    There is only about 5% of space left, so it is becoming critical.

    I have asked the developers to do some archiving, and although they say they can, and will do it - there is always something else that delays them from doing it.

    I will have to push on this issue, and also push for more space too.

    Thanks for your help.

    George

  • June 24, 2011 at 3:50 am

    #1343565

    Thanks also Muthukkumaran.

    I will check out the links you posted.

    Cheers,

    George

  • June 24, 2011 at 4:00 am

    #1343569

    gs1975 (6/24/2011)

    Thanks also Muthukkumaran.

    I will check out the links you posted.

    Cheers,

    George

    George your welcome. I didn't post any link.

    No problem see the link here

    Don't shrink the database instead of shrink the log file some crucial situation.(if you don’t have any other option)

    First check the database file size mdf & ldf

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 6 posts - 1 through 5 (of 5 total)

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