I was planning to re-index my database (225GB) this coming weekend however I
have just realised that it will be running through the server clock changing
(advancing 1 hour). Will this have any adverse effect on the procedure?
GavNo problem. The only thing to be careful with is when you go back in time,
and you have transactions occurring during that time, you can find yourself
in a position where you cannot do point in time restore for transaction that
occurred during that hour.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message
news:c3n37r$l3p$1@.hercules.btinternet.com...
> I was planning to re-index my database (225GB) this coming weekend however
I
> have just realised that it will be running through the server clock
changing
> (advancing 1 hour). Will this have any adverse effect on the procedure?
> Gav
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment