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/d...>
rt_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@microso
ft.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@microso
ft.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)