Jeffrey Williams (1/1/2009)

---

Database is so big, there are many unused backup tables in database, so I delete them and reduce Database size to easy manage. That's why I want to shrink

As your article, after shrinking, the log file size will increase. Then can I continue to shrink Log file after that?

What the matter if I setup target size smaller, ex 8GB? Can it automatically to be 10G?

Thanks

No - you don't want to shrink either the data file or the log file on a regular/scheduled basis. Do so will cause more problems than it is worth.

Please review the article I link to in my signature on how the manage transaction logs.