Daylight Time Saving - SQL Server 2008 Mirroring

Category: sql server mirroring


Gnana Balaji Kanagaraj on Wed, 05 Mar 2014 18:24:35

Dear SQL Forum Group Members,

1) Could anyone clarify me, will there be any issues in SQL server 2008 Mirroring because of Daylight Time saving ?? Also, will there be any impact on Tlog backup scheduled jobs which will be running in 15 Minutes interval.?

2) Do i need to reschedule my mirroring & scheduled jobs on Daylight saving days?? Is there manual(DBA) Intervention needed on these days??

Awaiting your valuable feedback.


Prashanth Jayaram on Wed, 05 Mar 2014 18:37:01

Nope, there won't be any impact on the database mirroring as it continually transfer the log.


Tom Phillips on Wed, 05 Mar 2014 18:44:43

No.  The clock time has no impact on the internal processing of SQL Server. 

SQL Agent has code to handle daylight savings time built in.