Solved

Change Server Timezone in SQL Server

Posted on 2009-07-08
5
1,889 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

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…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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.

734 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