Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-18 : 10:48:08
|
| ray writes "How often do you recommend rebooting sql 2k or 7 server ?Database size is less than 2 gig" |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-18 : 11:44:13
|
| My immediate answer would be, "as often as you can". But in all seriousness it depends on many factors, ie. server use, server configuration(memory), user needs, etc.. If the server can be scheduled to cycle weekly after performing some DBCC's that should be sufficient. I have some servers with databases in excess of 80GB that have DBCC's run nightly and then the server is cycled. I have this plan in place now as it gives me a 2 hour window that the users are aware of that I can perform service packs, maintenance, etc.. If you don't get it up front in a production environment chances are you will have problems in the future trying to get a window for these tasks. JMHOJamesH. |
 |
|
|
|
|
|
SQL server rebooting