Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1902
  • Last Modified:

Change Server Timezone in SQL Server

Hi

I would like to know if anyone has any experience with changing the server timezone on a sql box, the user has SQL server 2005 installed on a Server box which is currently set to a US time zone, he would like to know of any problems with changing the time zone to BST regarding the SQL database.
0
cntboys
Asked:
cntboys
  • 3
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
There is nothing like SQL Server Timezone.

All timezones are referred from your Server OS timezones.
Hence in your Regional Settings, change the timezone from US to BST and this should work fine.

You might feel some gaps for some of the records during this time change.
Hence it is best adviced to perform this activity in your maintenance window.
0
 
cntboysAuthor Commented:
"You might feel some gaps for some of the records during this time change"

Thanks for your reply, but can you clarify the above part of it
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
For eg: Assume if your current timezone is -5:30 and you are moving to GMT ie., 0:00.
Then current time of 20:30 will be corrected out there as 04:00 am the next day. Hence you feel gaps between these values.

Suppose if you run a query that finds difference between two records across these values, then you might find that as odd and I meant that one as gaps.

Hope this clarifies.
0
 
cntboysAuthor Commented:
Will these gaps still be apparent when users log back in if the change is odne out of hours?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> Will these gaps still be apparent when users log back in if the change is odne out of hours?

If you do it in a live machine these gaps will be apparent.
But if it is done in a known maintenance window, you can be sure that its a maintenance window in case you debug to find the cause of it.

Kindly analyze in your application whether any queries check for difference in hours / minutes so that you can be sure whether your system is impacted or not. If you dont have any queries like that, then you need not worry about that.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now