The change in time zone from UTC to BST (British Summer Time) after restarting your virtual machine (VM) can be attributed to several factors related to time zone settings and daylight saving time (DST) configurations.
Automatic Time Zone Adjustment: Many operating systems, especially those running in regions that observe DST, are configured to automatically switch between standard time (UTC) and daylight saving time (BST). If your VM is set to a location that observes DST, it may automatically adjust the time zone during the transition periods.
VM Configuration: If your VM was provisioned with a specific time zone setting that includes DST adjustments, it might revert to that setting upon reboot. This is common in cloud environments where the VM's time zone is set based on the region during provisioning.
Time Synchronization Services: If the VM is configured to synchronize its clock with an external time server, it might pull the local time settings from that server, which could include DST adjustments.
To maintain consistent time settings on a database VM, consider disabling automatic adjustments for DST or explicitly setting the time zone to UTC, which does not change with daylight saving transitions. This can help avoid potential issues with timestamps in database entries and logs.