I consider my self as newbie in the DBA field, and this is my first topic in the forums.
I took a .bak file in order to restore a db.When the restore completed,i came up with a
a DB operating in SIMPLE RECOVERY MODEL and with a LOG file about 8GB.Since the data is not crucial
I AM TAKING full BCK EVERY 8 HOURS.
THE LOG FILE HAS MANY VLF, SINCE THE AUTOGROWTH POLICY WAS THE DEFAULT (1mb 10%) ,AND MANY OF THEM ARE INACTIVE.
WHAT IS THE RECOMMNED WAY TO SHRINK THE LOG FILE PHYSICAL SIZE.
JUST EXECUTE THE SHRINK FILE COMMAND ON THE LOG FILE?
AND IS IT SAFE TO CHANGE THE LOG FILE SIZE AUTOGROWTH PROPERTY AFTER HE SHRINK OPREATION?
THANKS IN ADVANCE