Post reply

space noused

  • December 11, 2013 at 1:23 pm

    #285934

    Howdy Everybody,

    I have this information about my database:

    NAME data_allocateddata_usedlog_allocatedlog_usedrecovery_model_desc

    XXX 817108 4504391348 94 FULL

    I want to know how can I free unused space this database??

    thanks...

  • December 11, 2013 at 4:21 pm

    #1672785

    DBCC SHRNIKDATABASE(<db_name>)

    ..and don't forget to run INDEX REBUILD for all indexes because the SHRINK operation will introduce a lot of fragmentation.

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • December 11, 2013 at 4:51 pm

    #1672789

    Thanks you so much guy, but about this command:

    DBCC SHRNIKDATABASE(<db_name>)

    I use NOTRUNCATE, TRUNCATEONLY or some else?

    i dont understand the perfect functionality of notruncante, truncateonly... i just have a free space disk

  • December 11, 2013 at 5:00 pm

    #1672792

    LOVER OF SQL (12/11/2013)

    Thanks you so much guy, but about this command:

    DBCC SHRNIKDATABASE(<db_name>)

    I use NOTRUNCATE, TRUNCATEONLY or some else?

    i dont understand the perfect functionality of notruncante, truncateonly... i just have a free space disk

    Find it here http://technet.microsoft.com/en-us/library/ms190488.aspx

    You don't need to add additional options. However it's your choice.

    Igor Micev,My blog: www.igormicev.com

  • December 11, 2013 at 5:50 pm

    #1672799

    Thanks man!

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

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