Re: What are the effects of changing the system clock on SQL Serve

Thank you very much for the clarification.

"Dejan Sarka" wrote:
 
>
> If you think of the Transaction Log, then don't worry. The sequence is
> maintained by a Log Sequence Number, not by datetime.
> But maybe some of your apps use datetime data (maybe with GETDATE function
)
> for some purpose, and they might have some problems.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www. SolidQualityLearning
.com
>
>
>

But you will mess up your RESTORE-ability. If you do transaction log backup 
and expect to restore to
a certain point in time (STOPAT parameter to the RESTORE command), you will 
have a "dead spot" in
the transaction log when you go backwards in time on the machine.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/


"DDLooks" <DDLooks@discussions.microsoft.com> wrote in message
news:66A2543F-25AB-4702-A51B- 644151645284@microso
ft.com...
> Thank you very much for the clarification.
>
> "Dejan Sarka" wrote:
>