Results 1 to 3 of 3

Thread: database size

  1. #1
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    60

    Unanswered: database size

    Is there any shortest way to database size (data & log)

    I refer to Article ID: 256650 (reduce log file size)
    Quit a lot of step

    I want to reduce physical occupied HDD size

  2. #2
    Join Date
    Jun 2003
    Posts
    269
    refer BOL,
    dbcc shrinkdatabase and dbcc shrinkfile
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Chiwaki
    Before that I suggest you to assess the required value for Transaction log file, if you are trying to shrin the Tlog with DBCC SHRINKFILE and if the batch jobs such as bulk load and database maintenance will try to increase the size to process the statements.

    So it is better to assess the size in advance to avoid such Open/Close operation.

    Hope this helps.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •