locked
Daylight Time Saving - SQL Server 2008 Mirroring RRS feed

  • Question

  • 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.



    Wednesday, March 5, 2014 6:24 PM

Answers

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

    http://www.sqlskills.com/blogs/paul/how-does-daylight-savings-time-affect-disaster-recovery/


    -Prashanth

    • Proposed as answer by Shanky_621MVP Wednesday, March 5, 2014 7:04 PM
    • Marked as answer by Fanny Liu Tuesday, March 18, 2014 1:20 AM
    Wednesday, March 5, 2014 6:37 PM
  • 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.

    • Proposed as answer by Shanky_621MVP Wednesday, March 5, 2014 7:04 PM
    • Marked as answer by Fanny Liu Tuesday, March 18, 2014 1:20 AM
    Wednesday, March 5, 2014 6:44 PM

All replies

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

    http://www.sqlskills.com/blogs/paul/how-does-daylight-savings-time-affect-disaster-recovery/


    -Prashanth

    • Proposed as answer by Shanky_621MVP Wednesday, March 5, 2014 7:04 PM
    • Marked as answer by Fanny Liu Tuesday, March 18, 2014 1:20 AM
    Wednesday, March 5, 2014 6:37 PM
  • 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.

    • Proposed as answer by Shanky_621MVP Wednesday, March 5, 2014 7:04 PM
    • Marked as answer by Fanny Liu Tuesday, March 18, 2014 1:20 AM
    Wednesday, March 5, 2014 6:44 PM