Sql Server 2000 restarts

[grimwyre]

Running SQL server 2000 on W2K clustered nodes, is it "good practice" to restart SQL and/or reboot the nodes on a regular basis, apart from system upgrades?

Has anyone seen any articles on this subject, TechNet does not explicitly give any information.

 

[SQLBill]

I have an active/passive Win2K Advanced Server cluster with SQL Server 2000 on it. I rarely restart SQL or reboot the system. About once every two months I will fail the cluster over and back again just to test it. I also keep a close eye on my tempdb database. Restarting the SQL Service clears that out and I can use that as my day to test the failover. But really, I can't see any reason to fail it over (which is what rebooting will do).

-SQLBill

 

[SQLSister]

I agree with SQLBill, I never reboot my SQL server unless I have a specific reason to do so.