SQL Server, Auto Shrink, Log Files?

Results 1 to 3 of 3

Thread: SQL Server, Auto Shrink, Log Files?

  1. #1
    Join Date
    Dec 1969

    Default SQL Server, Auto Shrink, Log Files?

    Hi <BR><BR>My ISP is wanting to know the size of mt database and log files.<BR><BR>I know that the database is 5.36MB with 1.61MB space available.<BR>Why is there only 1.61MB available, I havent set any size settings, just added the database.<BR>I dont know anything about log files??? What are they?<BR><BR>Is Autoshrink similar to Access&#039;s compact and repair? Should this be enabled?<BR><BR>Could someone please explain these to me.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server, Auto Shrink, Log Files?

    depending on how you have the files set up, there&#039;s usually x amount of &#039;empty&#039; space at the end of your file, which is expanded when SQL Server decides it needs more room.<BR><BR>the default should be to grow by 10% when required. Autoshrink is kinda similar. what it does best is keep regularly cycled databases from overgrowing their limits. it&#039;s worth running a scheduled maintainence task on there to kep them all nice and clean, though.<BR><BR>there&#039;s more detail in Books Online<BR><BR><BR>j<BR>http://rtfm.atrax.co.uk/

  3. #3
    Join Date
    Dec 1969

    Default Watch this Flash Presentation

    It will help you understand this and how to create maintenance plans to manage it:<BR><BR>http://www.eggheadcafe.com/videodemo/default.asp

Posting Permissions

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