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

Author

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

DDLooks

2005-12-30, 8:23 pm

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

Tibor Karaszi

2005-12-31, 3:23 am

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...[color=darkred]
> Thank you very much for the clarification.
>
> "Dejan Sarka" wrote:
>

Sponsored Links