Re: Schedule windows server and sql server reboot weekly

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

If you restart your windows operating system then automatically your SQL Services will also get restarted. Hence use OS scheduler to reboot the windows machine. Below article can give you an idea

http://forums.techarena.in/windows-server-help/554012.htm
http://articles.techrepublic.com.com/5100-10878_11-6086387.html

Thanks,
Vidhya Sagar

"db" <db@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4EF9AEE1-5ECD-49AE-B5E1-87C8CF4AD53D@xxxxxxxxxxxxxxxx
Microsoft SQL server standard edition
Microsoft windows NT 5.2 (3790)
Platform: NT INTEL X86
Version: 8.00.2039
SQL server 2000 SP4

I have been told to automate rebooting of windows server and sql server and
schedule it for every sunday morning. How do I schedule it?

dbdba
--
ontario, canada
.

Relevant Pages

  • RE: Scheduled Reboot
    ... I suggest you just schedule the ... C:\Windows\System32\shutdown -r command and check if it works. ... | Subject: RE: Scheduled Reboot ... |>Does it work when the user logs on to the Windows XP ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Cant view reg key HKLMSWMSWindowsCurrentVersion
    ... Yes, we checked all of the permissions, but were unable to propogate them to ... A reboot fixed the problem completely. ... Microsoft MVP: Windows Server ... database server running SQL 2000. ...
    (microsoft.public.windows.server.general)
  • Cant view reg key HKLMSWMSWindowsCurrentVersion
    ... I have a Windows 2003 Server. ... database server running SQL 2000. ... a reboot to fix the registry problems? ...
    (microsoft.public.windows.server.general)
  • Re: setting up Daily automatic reboots?
    ... Schedule it with Task Scheduler ... Does anyone know of a good way to set Windows 2000 ... | do not reboot and change the schedule. ...
    (microsoft.public.win2000.general)
  • Re: CHKDSK fails
    ... Schedule chkdsk and reboot in Safe Mode. ... The /SAFEBOOT switch causes Windows to start in Safe Mode. ... Then before you shutdown or reboot again, ...
    (microsoft.public.windowsxp.help_and_support)