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
  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.

Share This Page