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

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

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 n
ot
> 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... 
>
>
>