nightly rebooting of server

SQL 2000 patched up running under SBS2003
we shutdown and reboot automatically at 2AM into DOS and backup entire
server via Ghost onto a backup and drive and restart server
Question: are there any issues with rebooting SQL daily?
a another consultant claims there are but I can find no mentions in MS db or
literature.
craig@.computermagic.net(donotspam)
Hi
If you cleanly shut down SQL server there should be no issue
http://msdn.microsoft.com/library/de...tart_6628.asp,
but anything connected to the server would need to handle this loss.
John
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
|||The only issue is that you are blowing away your data cache and query cache,
so this is why queries in the morning run a lot more slowly than they do in
the afternoon.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)