advlgx
asked on
When do transaction log files release and reset to a smaller size?
I am doing a full backup of a SIMPLE logged database that used to be set as FULL, yet the transaction log does not reduce in size. It has grown to be 300MB.
1. Is this normal?
2. How and when do transaction logs purge/reset themselves to their smallest size?
3. What do I have to do to manage them?
1. Is this normal?
2. How and when do transaction logs purge/reset themselves to their smallest size?
3. What do I have to do to manage them?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.