Solved

Change Server Timezone in SQL Server

Posted on 2009-07-08
5
1,886 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS - Date Report Options 2 29
Download ms sql express. 2 28
MS SQL AND PASSING A TABLE NAME TO A SPROC 5 18
MS SQL Conditional WHERE clause 3 17
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

820 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