Results 1 to 4 of 4

Thread: Shrinking SQL 2005 Log Files Automatically

  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Question Shrinking SQL 2005 Log Files Automatically

    I know how to shrink the log files already, however, does anyone know how this can be done automatically, perhaps on a periodical basis?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can set sql job for that, but not good practice to shrink log periodlically.

  3. #3
    Join Date
    Feb 2009
    Posts
    2

    Why?

    Why do you say that it's not good practice? How do I go about setting the SQL job to do this?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    It'll grow again, so you get double performance hit. Better to control log with with proper log backup plan. If you really like to do, just run 'dbcc shrinkfile' as sql job.

Posting Permissions

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