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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs