| Author |
nightly rebooting of server
|
|
| computermagic 2005-12-31, 1:23 pm |
| 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)
| |
| John Bell 2005-12-31, 8:23 pm |
| Hi
If you cleanly shut down SQL server there should be no issue
http://msdn.microsoft.com/library/d...start_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)
| |
| Michael Hotek 2005-12-31, 8:23 pm |
| 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)
|
|
|
|