MS SQL Server 2000 on Windows 2003 SP1: SP3a or SP4?

Hi,
I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
just fine for SQL Server or should I apply SP4, which is not yet tested with
the application, and why?
Are there any differences between installing SQL Server 2000 on Windows 2000
Server SP4 and Windows Server 2003 SP1 and what are they, if any?
--
Many thanks,
OskAt a minimum you need 3a. You might want to consider SP4. Make sure that
you take a look at the following pages so that you have the information that
you need to make your own determination:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
http://www.microsoft.com/sql/downloads/2000/sp3.asp
--
Keith
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:BD8FF29E-57A3-4A04-9BF0-6698EF153DE3@.microsoft.com...
> Hi,
> I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
> just fine for SQL Server or should I apply SP4, which is not yet tested
> with
> the application, and why?
> Are there any differences between installing SQL Server 2000 on Windows
> 2000
> Server SP4 and Windows Server 2003 SP1 and what are they, if any?
> --
> Many thanks,
> Osk
>

MS SQL Server 2000 on Windows 2003 SP1: SP3a or SP4?

Hi,
I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
just fine for SQL Server or should I apply SP4, which is not yet tested with
the application, and why?
Are there any differences between installing SQL Server 2000 on Windows 2000
Server SP4 and Windows Server 2003 SP1 and what are they, if any?
Many thanks,
OskAt a minimum you need 3a. You might want to consider SP4. Make sure that
you take a look at the following pages so that you have the information that
you need to make your own determination:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Keith
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:BD8FF29E-57A3-4A04-9BF0-6698EF153DE3@.microsoft.com...
> Hi,
> I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
> just fine for SQL Server or should I apply SP4, which is not yet tested
> with
> the application, and why?
> Are there any differences between installing SQL Server 2000 on Windows
> 2000
> Server SP4 and Windows Server 2003 SP1 and what are they, if any?
> --
> Many thanks,
> Osk
>sql

MS SQL Server 2000 on Windows 2003 SP1: SP3a or SP4?

Hi,
I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
just fine for SQL Server or should I apply SP4, which is not yet tested with
the application, and why?
Are there any differences between installing SQL Server 2000 on Windows 2000
Server SP4 and Windows Server 2003 SP1 and what are they, if any?
Many thanks,
Osk
At a minimum you need 3a. You might want to consider SP4. Make sure that
you take a look at the following pages so that you have the information that
you need to make your own determination:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Keith
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:BD8FF29E-57A3-4A04-9BF0-6698EF153DE3@.microsoft.com...
> Hi,
> I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
> just fine for SQL Server or should I apply SP4, which is not yet tested
> with
> the application, and why?
> Are there any differences between installing SQL Server 2000 on Windows
> 2000
> Server SP4 and Windows Server 2003 SP1 and what are they, if any?
> --
> Many thanks,
> Osk
>

MS SQL Backup Schedule

When I try to schedule a COMPLETE backup to Disk, I select the overwrite box
and schedule. Then I select DAILY and a Time, click apply, and then OK. Whe
n
I go back in to review the setting it is back the way it was with no
schedule.
What am I doing wrong ?I'm unable to reproduce this on my sql2k+sp3a. Perhaps, you want to update
to the latest service pack.
http://microsoft.com/sql
"Gerrym" <Gerrym@.discussions.microsoft.com> wrote in message
news:CC53F517-4247-4CA8-9477-2225742E3494@.microsoft.com...
> When I try to schedule a COMPLETE backup to Disk, I select the overwrite
box
> and schedule. Then I select DAILY and a Time, click apply, and then OK.
When
> I go back in to review the setting it is back the way it was with no
> schedule.
> What am I doing wrong ?|||That dialog only creates an SQL Server agent job. Check in SQL Server Agent,
Jobs and you will see
you job(s) there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gerrym" <Gerrym@.discussions.microsoft.com> wrote in message
news:CC53F517-4247-4CA8-9477-2225742E3494@.microsoft.com...
> When I try to schedule a COMPLETE backup to Disk, I select the overwrite b
ox
> and schedule. Then I select DAILY and a Time, click apply, and then OK. W
hen
> I go back in to review the setting it is back the way it was with no
> schedule.
> What am I doing wrong ?|||Thank you Tibor, where can I see the scheduled jobs ?
gerrym
"Tibor Karaszi" wrote:

> That dialog only creates an SQL Server agent job. Check in SQL Server Agen
t, Jobs and you will see
> you job(s) there.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gerrym" <Gerrym@.discussions.microsoft.com> wrote in message
> news:CC53F517-4247-4CA8-9477-2225742E3494@.microsoft.com...
>
>|||Enterprise Manager, Management, SQL Server Agent, Jobs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gerrym" <Gerrym@.discussions.microsoft.com> wrote in message
news:7DC355DB-A511-4B91-A46D-17B309D4879C@.microsoft.com...[vbcol=seagreen]
> Thank you Tibor, where can I see the scheduled jobs ?
> gerrym
> "Tibor Karaszi" wrote:
>
see[vbcol=seagreen]

MS SQL Backup Schedule

When I try to schedule a COMPLETE backup to Disk, I select the overwrite box
and schedule. Then I select DAILY and a Time, click apply, and then OK. When
I go back in to review the setting it is back the way it was with no
schedule.
What am I doing wrong ?
I'm unable to reproduce this on my sql2k+sp3a. Perhaps, you want to update
to the latest service pack.
http://microsoft.com/sql
"Gerrym" <Gerrym@.discussions.microsoft.com> wrote in message
news:CC53F517-4247-4CA8-9477-2225742E3494@.microsoft.com...
> When I try to schedule a COMPLETE backup to Disk, I select the overwrite
box
> and schedule. Then I select DAILY and a Time, click apply, and then OK.
When
> I go back in to review the setting it is back the way it was with no
> schedule.
> What am I doing wrong ?
|||That dialog only creates an SQL Server agent job. Check in SQL Server Agent, Jobs and you will see
you job(s) there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gerrym" <Gerrym@.discussions.microsoft.com> wrote in message
news:CC53F517-4247-4CA8-9477-2225742E3494@.microsoft.com...
> When I try to schedule a COMPLETE backup to Disk, I select the overwrite box
> and schedule. Then I select DAILY and a Time, click apply, and then OK. When
> I go back in to review the setting it is back the way it was with no
> schedule.
> What am I doing wrong ?
|||Thank you Tibor, where can I see the scheduled jobs ?
gerrym
"Tibor Karaszi" wrote:

> That dialog only creates an SQL Server agent job. Check in SQL Server Agent, Jobs and you will see
> you job(s) there.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gerrym" <Gerrym@.discussions.microsoft.com> wrote in message
> news:CC53F517-4247-4CA8-9477-2225742E3494@.microsoft.com...
>
>
|||Enterprise Manager, Management, SQL Server Agent, Jobs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gerrym" <Gerrym@.discussions.microsoft.com> wrote in message
news:7DC355DB-A511-4B91-A46D-17B309D4879C@.microsoft.com...[vbcol=seagreen]
> Thank you Tibor, where can I see the scheduled jobs ?
> gerrym
> "Tibor Karaszi" wrote:
see[vbcol=seagreen]