Helenp1983
MIS
We are using logshipping and log file names are in the format yyyymmddhhmmss.trn but the time the file was created is say 9:45 but the file name is 2008100184500.trn
Its 1 hour out. I am in the UK, the time on the server is correct it is 9:45 and we are using daylight savings.
I ran this query
SELECT CURRENT_TIMESTAMP
GO
SELECT {fn NOW()}
GO
SELECT GETDATE()
GO
and the time came back correct, but the time on the log files is 1 hour behind.
How do i change this?
Its 1 hour out. I am in the UK, the time on the server is correct it is 9:45 and we are using daylight savings.
I ran this query
SELECT CURRENT_TIMESTAMP
GO
SELECT {fn NOW()}
GO
SELECT GETDATE()
GO
and the time came back correct, but the time on the log files is 1 hour behind.
How do i change this?
