-
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?
-
You can set sql job for that, but not good practice to shrink log periodlically.
-
Why?
Why do you say that it's not good practice? How do I go about setting the SQL job to do this?
-
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
-
Forum Rules
|
|