SOLVED

LinuxSQL 2019 timezones

%3CLINGO-SUB%20id%3D%22lingo-sub-2735100%22%20slang%3D%22en-US%22%3ELinuxSQL%202019%20timezones%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2735100%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20working%20on%20Linux%20SQL%202019%20on%20CentOS8.%20I%20created%20a%20VM%20which%20was%20in%20EST%20timezone%20and%20installed%20SQL.%20Later%20I%20changed%20the%20system%20timezone%20to%20IST%20but%20SQL%20timezone%20remained%20in%20EST.%20I%20had%20to%20restart%20the%20services%20for%20SQL%20to%20sync%20with%20system%20timezone.%20Is%20there%20a%20way%20that%20SQL%20can%20update%20its%20timezone%20to%20system%20TZ%20without%20restarting%20the%20services%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2738837%22%20slang%3D%22en-US%22%3ERe%3A%20LinuxSQL%202019%20timezones%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2738837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1150660%22%20target%3D%22_blank%22%3E%40denuvo5%3C%2FA%3E%26nbsp%3B%2C%20no%2C%20SQL%20Server%20pickup%20the%20system%20settings%20on%20startup.%3C%2FP%3E%3CP%3EInstall%20the%20OS%20the%20right%20way%20as%20required%20and%20then%20SQL%20Server.%20Later%20changes%20always%20can%20cause%2Frequires%20a%20restart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOlaf%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I was working on Linux SQL 2019 on CentOS8. I created a VM which was in EST timezone and installed SQL. Later I changed the system timezone to IST but SQL timezone remained in EST. I had to restart the services for SQL to sync with system timezone. Is there a way that SQL can update its timezone to system TZ without restarting the services?

2 Replies
best response confirmed by denuvo5 (New Contributor)
Solution

@denuvo5 , no, SQL Server pickup the system settings on startup.

Install the OS the right way as required and then SQL Server. Later changes always can cause/requires a restart.

 

Olaf

Thanks @olafhelper