SQL Server Performance

Shrinking database

Discussion in 'T-SQL Performance Tuning for Developers' started by jagpalsingh4, Sep 3, 2008.

  1. jagpalsingh4 New Member

    Hi,
    I used this script for shrinking database ,but i read somewhere that dont use shrink command if its bigger than 5gb and i dont know what the use of 1 and 10 in this script .

    dump tran HFM with no_log;
    DBCC SHRINKdatabase(HFM,1)
    DBCC SHRINKFILE(HFM_Log, 10)
    so plz help and give me ur suggestion
    Regards
    Jagpal singh
    jagpalsingh4, Sep 3, 2008
    #2

  2. MohammedU New Member

    First of all why you want to shrink the database and how much you want to shrink?
    Check the Books online for more details.
    1 mean you are asking SQL server shrink the DATA file to 1 MB.
    10 mean you are asking SQL server shrink the LOG file to 10 MB.
    MohammedU, Sep 3, 2008
    #3

Share This Page