Scheduled reboot of SQL Server on Windows 2000

I am descerning whether it is a good idea (or necessary) to reboot our SQL
Server 2000 servers on a regular basis (E.g., monthly or quarterly). Are
there any performance benefits in doing this? Does this help to defragment
memory?
There's no real benefit. However, you will likely incur a performance
penalty each time, since it will have to repopulate the data cache.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Cajun" <Cajun@.discussions.microsoft.com> wrote in message
news:FECF4E55-A44B-42CE-86E0-9D0915BD6490@.microsoft.com...
I am descerning whether it is a good idea (or necessary) to reboot our SQL
Server 2000 servers on a regular basis (E.g., monthly or quarterly). Are
there any performance benefits in doing this? Does this help to defragment
memory?
|||Hi -
Experts says :-
"This is a fairly common question, and the answer is fairly straight
forward, no. Assuming you are using Windows NT Server 4.0 SP6a, or Windows
2000 Server SP4, or Windows 2003 Server, and are running SQL Server 7.0 or
2000 (any service packs), there is no reason to automatically reboot your
server. Doing so will not offer you any performance benefits or enhance
reliability.
There is a common myth among many IS people that Windows Server software
needs to be rebooted regularly for it to work efficiently. There may have
been a grain of truth to this in previous versions of Windows NT Server
(before 4.0), but since 4.0, there has not been any need to reboot Windows
Server on a regular basis.
I have seen many, many Windows servers that are virtually never rebooted,
and they never have any problems due to the OS.
On the other hand, I have seen poorly written applications written for
Windows Server that have memory leaks that have force the need to reboot the
server on a regular basis. But this problem is the fault of the application,
not the OS. It is very possible that less knowledgeable IS staff in general
have improperly diagnosed the cause of a server's problem and blamed it on
the OS, and not the application as they should, which is perpetuating this
myth.
Since your SQL Server is not having any problems, leave it alone, and tell
the other people on your staff to stop listening to urban legends."
"Cajun" wrote:

> I am descerning whether it is a good idea (or necessary) to reboot our SQL
> Server 2000 servers on a regular basis (E.g., monthly or quarterly). Are
> there any performance benefits in doing this? Does this help to defragment
> memory?

Scheduled reboot of SQL Server on Windows 2000

I am descerning whether it is a good idea (or necessary) to reboot our SQL
Server 2000 servers on a regular basis (E.g., monthly or quarterly). Are
there any performance benefits in doing this? Does this help to defragment
memory?There's no real benefit. However, you will likely incur a performance
penalty each time, since it will have to repopulate the data cache.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Cajun" <Cajun@.discussions.microsoft.com> wrote in message
news:FECF4E55-A44B-42CE-86E0-9D0915BD6490@.microsoft.com...
I am descerning whether it is a good idea (or necessary) to reboot our SQL
Server 2000 servers on a regular basis (E.g., monthly or quarterly). Are
there any performance benefits in doing this? Does this help to defragment
memory?|||Hi -
Experts says :-
"This is a fairly common question, and the answer is fairly straight
forward, no. Assuming you are using Windows NT Server 4.0 SP6a, or Windows
2000 Server SP4, or Windows 2003 Server, and are running SQL Server 7.0 or
2000 (any service packs), there is no reason to automatically reboot your
server. Doing so will not offer you any performance benefits or enhance
reliability.
There is a common myth among many IS people that Windows Server software
needs to be rebooted regularly for it to work efficiently. There may have
been a grain of truth to this in previous versions of Windows NT Server
(before 4.0), but since 4.0, there has not been any need to reboot Windows
Server on a regular basis.
I have seen many, many Windows servers that are virtually never rebooted,
and they never have any problems due to the OS.
On the other hand, I have seen poorly written applications written for
Windows Server that have memory leaks that have force the need to reboot the
server on a regular basis. But this problem is the fault of the application,
not the OS. It is very possible that less knowledgeable IS staff in general
have improperly diagnosed the cause of a server's problem and blamed it on
the OS, and not the application as they should, which is perpetuating this
myth.
Since your SQL Server is not having any problems, leave it alone, and tell
the other people on your staff to stop listening to urban legends."
"Cajun" wrote:

> I am descerning whether it is a good idea (or necessary) to reboot our SQL
> Server 2000 servers on a regular basis (E.g., monthly or quarterly). Are
> there any performance benefits in doing this? Does this help to defragmen
t
> memory?sql

scheduled job status is "performing completion actions"

Any idea what this means. I tried stopping the job and deleting it but I
couldn't do either.
Thanks,
Dan D.
Hi,
by my experiance it usually means that SQL Server Agent is cleaning up
temporary object it has created during execution of job.
Usually it is fast so you cannot see it but sometimes it takes time,
especially if there is a lot of data.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.
|||I forgot to say that it has been that way for over 2 weeks so something must
be wrong. But I can't remove it so I'm not sure what to do about it.
"Danijel Novak" wrote:

> Hi,
> by my experiance it usually means that SQL Server Agent is cleaning up
> temporary object it has created during execution of job.
> Usually it is fast so you cannot see it but sometimes it takes time,
> especially if there is a lot of data.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>
|||Dan
What does the job do?
Perhasps you might look at Task Manager to see what happened.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.
|||The job is a dts package that does some inserts, deletes and updates to
various tables.
"Uri Dimant" wrote:

> Dan
> What does the job do?
> Perhasps you might look at Task Manager to see what happened.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>
|||"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> I forgot to say that it has been that way for over 2 weeks so something
must
> be wrong. But I can't remove it so I'm not sure what to do about it.
>
I'll bet you've got it setup to email upon completion and SQL Mail isn't
working.
Tht's when I've generally seen it.
[vbcol=seagreen]
> "Danijel Novak" wrote:
I[vbcol=seagreen]
|||There are no email notifications in the package. And our SQLMail is working.
Every step is an execute sql task.
"Greg D. Moore (Strider)" wrote:

> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> must
> I'll bet you've got it setup to email upon completion and SQL Mail isn't
> working.
> Tht's when I've generally seen it.
>
> I
>
>
|||Hi,
Did you try to restart SQL Server Agent?
Maybe restart could stop the job.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...[vbcol=seagreen]
>I forgot to say that it has been that way for over 2 weeks so something
>must
> be wrong. But I can't remove it so I'm not sure what to do about it.
> "Danijel Novak" wrote:
|||I was finally able to delete the job. I created a new one.
Thanks,
"Danijel Novak" wrote:

> Hi,
> Did you try to restart SQL Server Agent?
> Maybe restart could stop the job.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
>
>

scheduled job status is "performing completion actions"

Any idea what this means. I tried stopping the job and deleting it but I
couldn't do either.
Thanks,
--
Dan D.Hi,
by my experiance it usually means that SQL Server Agent is cleaning up
temporary object it has created during execution of job.
Usually it is fast so you cannot see it but sometimes it takes time,
especially if there is a lot of data.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.|||I forgot to say that it has been that way for over 2 weeks so something must
be wrong. But I can't remove it so I'm not sure what to do about it.
"Danijel Novak" wrote:
> Hi,
> by my experiance it usually means that SQL Server Agent is cleaning up
> temporary object it has created during execution of job.
> Usually it is fast so you cannot see it but sometimes it takes time,
> especially if there is a lot of data.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> > Any idea what this means. I tried stopping the job and deleting it but I
> > couldn't do either.
> >
> > Thanks,
> > --
> > Dan D.
>
>|||Dan
What does the job do?
Perhasps you might look at Task Manager to see what happened.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.|||The job is a dts package that does some inserts, deletes and updates to
various tables.
"Uri Dimant" wrote:
> Dan
> What does the job do?
> Perhasps you might look at Task Manager to see what happened.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> > Any idea what this means. I tried stopping the job and deleting it but I
> > couldn't do either.
> >
> > Thanks,
> > --
> > Dan D.
>
>|||"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> I forgot to say that it has been that way for over 2 weeks so something
must
> be wrong. But I can't remove it so I'm not sure what to do about it.
>
I'll bet you've got it setup to email upon completion and SQL Mail isn't
working.
Tht's when I've generally seen it.
> "Danijel Novak" wrote:
> > Hi,
> >
> > by my experiance it usually means that SQL Server Agent is cleaning up
> > temporary object it has created during execution of job.
> > Usually it is fast so you cannot see it but sometimes it takes time,
> > especially if there is a lot of data.
> >
> > Danijel
> >
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> > > Any idea what this means. I tried stopping the job and deleting it but
I
> > > couldn't do either.
> > >
> > > Thanks,
> > > --
> > > Dan D.
> >
> >
> >|||There are no email notifications in the package. And our SQLMail is working.
Every step is an execute sql task.
"Greg D. Moore (Strider)" wrote:
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> > I forgot to say that it has been that way for over 2 weeks so something
> must
> > be wrong. But I can't remove it so I'm not sure what to do about it.
> >
> I'll bet you've got it setup to email upon completion and SQL Mail isn't
> working.
> Tht's when I've generally seen it.
>
> > "Danijel Novak" wrote:
> >
> > > Hi,
> > >
> > > by my experiance it usually means that SQL Server Agent is cleaning up
> > > temporary object it has created during execution of job.
> > > Usually it is fast so you cannot see it but sometimes it takes time,
> > > especially if there is a lot of data.
> > >
> > > Danijel
> > >
> > >
> > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> > > > Any idea what this means. I tried stopping the job and deleting it but
> I
> > > > couldn't do either.
> > > >
> > > > Thanks,
> > > > --
> > > > Dan D.
> > >
> > >
> > >
>
>|||Hi,
Did you try to restart SQL Server Agent?
Maybe restart could stop the job.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
>I forgot to say that it has been that way for over 2 weeks so something
>must
> be wrong. But I can't remove it so I'm not sure what to do about it.
> "Danijel Novak" wrote:
>> Hi,
>> by my experiance it usually means that SQL Server Agent is cleaning up
>> temporary object it has created during execution of job.
>> Usually it is fast so you cannot see it but sometimes it takes time,
>> especially if there is a lot of data.
>> Danijel
>>
>> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>> > Any idea what this means. I tried stopping the job and deleting it but
>> > I
>> > couldn't do either.
>> >
>> > Thanks,
>> > --
>> > Dan D.
>>|||I was finally able to delete the job. I created a new one.
Thanks,
"Danijel Novak" wrote:
> Hi,
> Did you try to restart SQL Server Agent?
> Maybe restart could stop the job.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> >I forgot to say that it has been that way for over 2 weeks so something
> >must
> > be wrong. But I can't remove it so I'm not sure what to do about it.
> >
> > "Danijel Novak" wrote:
> >
> >> Hi,
> >>
> >> by my experiance it usually means that SQL Server Agent is cleaning up
> >> temporary object it has created during execution of job.
> >> Usually it is fast so you cannot see it but sometimes it takes time,
> >> especially if there is a lot of data.
> >>
> >> Danijel
> >>
> >>
> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> >> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> >> > Any idea what this means. I tried stopping the job and deleting it but
> >> > I
> >> > couldn't do either.
> >> >
> >> > Thanks,
> >> > --
> >> > Dan D.
> >>
> >>
> >>
>
>

scheduled job status is "performing completion actions"

Any idea what this means. I tried stopping the job and deleting it but I
couldn't do either.
Thanks,
--
Dan D.Hi,
by my experiance it usually means that SQL Server Agent is cleaning up
temporary object it has created during execution of job.
Usually it is fast so you cannot see it but sometimes it takes time,
especially if there is a lot of data.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.|||I forgot to say that it has been that way for over 2 weeks so something must
be wrong. But I can't remove it so I'm not sure what to do about it.
"Danijel Novak" wrote:

> Hi,
> by my experiance it usually means that SQL Server Agent is cleaning up
> temporary object it has created during execution of job.
> Usually it is fast so you cannot see it but sometimes it takes time,
> especially if there is a lot of data.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>|||Dan
What does the job do?
Perhasps you might look at Task Manager to see what happened.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.|||The job is a dts package that does some inserts, deletes and updates to
various tables.
"Uri Dimant" wrote:

> Dan
> What does the job do?
> Perhasps you might look at Task Manager to see what happened.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>|||"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> I forgot to say that it has been that way for over 2 weeks so something
must
> be wrong. But I can't remove it so I'm not sure what to do about it.
>
I'll bet you've got it setup to email upon completion and SQL Mail isn't
working.
Tht's when I've generally seen it.
[vbcol=seagreen]
> "Danijel Novak" wrote:
>
I[vbcol=seagreen]|||There are no email notifications in the package. And our SQLMail is working.
Every step is an execute sql task.
"Greg D. Moore (Strider)" wrote:

> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> must
> I'll bet you've got it setup to email upon completion and SQL Mail isn't
> working.
> Tht's when I've generally seen it.
>
> I
>
>|||Hi,
Did you try to restart SQL Server Agent?
Maybe restart could stop the job.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...[vbcol=seagreen]
>I forgot to say that it has been that way for over 2 weeks so something
>must
> be wrong. But I can't remove it so I'm not sure what to do about it.
> "Danijel Novak" wrote:
>|||I was finally able to delete the job. I created a new one.
Thanks,
"Danijel Novak" wrote:

> Hi,
> Did you try to restart SQL Server Agent?
> Maybe restart could stop the job.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
>
>

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nickCreate a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nick
Create a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:

> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>
|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nickCreate a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:

> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>