Post reply

how to reduce database size

  • August 8, 2003 at 4:09 am

    #59475

    I had created a database with autogrow but now i find that database size is 1.3 gb so i have asked the user to remove the data from database now there is only 100mb of data but my database size is shown as 1.3gb.how can i reduce the database size to 100mb so that harddisk space is freed .looking for valuable inputs in this regard.

  • August 8, 2003 at 4:18 am

    #469155

    You can shrink the database manually (from EM right-click on the DB, choose All Tasks, Shrink Database) or set it for autoshrink (from EM right-click choose Properties, options).

    The former is recommended.

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 8, 2003 at 6:29 am

    #469164

    Or, you can use the dbcc shrinkdatabase command. See below:

    DBCC SHRINKDATABASE

    ( database_name [ , target_percent ]

    [ , { NOTRUNCATE | TRUNCATEONLY } ]

    )

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

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