Solved

Change Server Timezone in SQL Server

Posted on 2009-07-08
5
1,884 Views
Last Modified: 2012-05-07
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
Comment
Question by:cntboys
  • 3
  • 2
5 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24801633
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
 

Author Comment

by:cntboys
ID: 24801689
"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
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24801866
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
 

Author Comment

by:cntboys
ID: 24802019
Will these gaps still be apparent when users log back in if the change is odne out of hours?
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24802032
>> 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS 2013 - Creating a summarized report 19 35
SSRS 2013 - Overlapping reports 2 22
Create snapshot on MSSQL 2012 3 18
T-SQL:  Collapsing 9 25
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question