|
Home > Archive > MS SQL Server > February 2006 > SQL Server Service
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server Service
|
|
|
| Hi:
When sql server service stops and restarts again other than manually doing
it or restarting the server. Does or can it happen on a set schedule, for
example, nighly basis?
Thanks
| |
| Dan Guzman 2006-02-25, 9:27 am |
| Stopping and starting a SQL Server service via a NET STOP and NET START
commands could be scheduled using Windows Task scheduler. However, this not
usually done regularly. SQL Server is usually left running 24x7.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike" <Mike@discussions.microsoft.com> wrote in message
news:E91F75F5-9288-431A-AE0B- BAB09C820D5A@microso
ft.com...
> Hi:
>
> When sql server service stops and restarts again other than manually doing
> it or restarting the server. Does or can it happen on a set schedule, for
> example, nighly basis?
>
> Thanks
| |
| smackie 2006-02-28, 8:23 pm |
| Agreed. Yuo should leave SQL running so that it can build up its data cache,
which will in turn improve performance.
"Dan Guzman" wrote:
> Stopping and starting a SQL Server service via a NET STOP and NET START
> commands could be scheduled using Windows Task scheduler. However, this not
> usually done regularly. SQL Server is usually left running 24x7.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Mike" <Mike@discussions.microsoft.com> wrote in message
> news:E91F75F5-9288-431A-AE0B- BAB09C820D5A@microso
ft.com...
>
>
>
|
|
|
|
|