Hello,

One of our Windows 2000 Servers is running SQL 2000 SP3. We need to advance
the system date on the machine to perform some application testing. After
testing is complete, we would fall back to the current date/time. How would
this affect SQL Server operation and database recoverability ?

Any help would be greatly appreciated.

Thank You.

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

Thank you very much for the clarification.

"Dejan Sarka" wrote:

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 (AT) discussions (DOT) microsoft.com> wrote