sql server tools: sp4

Showing posts with label sp4. Show all posts

Thursday, March 22, 2012

April Security Patches and SQL Server

We are running SQL Server 2000/sp3a on a relatively new server sized to meet
our needs for the foreseeable future. The OS is Win2k/sp4. It has been
running very well since installed; the last reboot was over a month ago and
that was scheduled for security updates.
On Monday evening, we installed the April security patches:
Microsoft KB837001 MS04-014:Vulnerability in Microsoft Jet Database Engine
could permit code execution
Microsoft KB828741 MS04-012: Cumulative Update for Microsoft RPC/DCOM
Microsoft KB835732 MS04-011: Security Update for Microsoft Windows
Microsoft KB837009 MS04-013: Cumulative Security Update for Outlook Express
Microsoft KB831167: Wininet retries POST requests with a blank header.
...via SUS. The server has been averaging three unscheduled reboots per day
since. If anyone has any ideas, I would be most grateful. We have had little
luck analyzing the dump file. My guess is that it has something to do with
the RPC/DCOM patch, since it is serving data for several third party web and
windows client applications.
Thanks,
JohnI don't know how to solve your issue, but I would recommend you call
Microsoft Product Support Services (MS PSS).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
news:esSncLKKEHA.2884@.TK2MSFTNGP12.phx.gbl...
> We are running SQL Server 2000/sp3a on a relatively new server sized to
meet
> our needs for the foreseeable future. The OS is Win2k/sp4. It has been
> running very well since installed; the last reboot was over a month ago
and
> that was scheduled for security updates.
> On Monday evening, we installed the April security patches:
> Microsoft KB837001 MS04-014:Vulnerability in Microsoft Jet Database Engine
> could permit code execution
> Microsoft KB828741 MS04-012: Cumulative Update for Microsoft RPC/DCOM
> Microsoft KB835732 MS04-011: Security Update for Microsoft Windows
> Microsoft KB837009 MS04-013: Cumulative Security Update for Outlook
Express
> Microsoft KB831167: Wininet retries POST requests with a blank header.
> ...via SUS. The server has been averaging three unscheduled reboots per
day
> since. If anyone has any ideas, I would be most grateful. We have had
little
> luck analyzing the dump file. My guess is that it has something to do with
> the RPC/DCOM patch, since it is serving data for several third party web
and
> windows client applications.
> Thanks,
> John
>|||Mark,
Thanks, for the response. I guess it is time to use up one of our MSDN
support calls. This set of patches has significantly reduced the
availability of two servers that had been running with no problems for
months, and of course, since it includes the RPC/DCOM patch, we cannot
remove the patch since this is an exploit that requires no I/O (inadequate
operator) action.
Curious though that neither my original post or your response displayed in
the newsgroup. I only found your response, by searching the forum for the
subject line of my post. Is Microsoft taking editorial license?
Cheers,
John
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:uigrjjQKEHA.3944@.tk2msftngp13.phx.gbl...
> I don't know how to solve your issue, but I would recommend you call
> Microsoft Product Support Services (MS PSS).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
> news:esSncLKKEHA.2884@.TK2MSFTNGP12.phx.gbl...
> > We are running SQL Server 2000/sp3a on a relatively new server sized to
> meet
> > our needs for the foreseeable future. The OS is Win2k/sp4. It has been
> > running very well since installed; the last reboot was over a month ago
> and
> > that was scheduled for security updates.
> >
> > On Monday evening, we installed the April security patches:
> >
> > Microsoft KB837001 MS04-014:Vulnerability in Microsoft Jet Database
Engine
> > could permit code execution
> > Microsoft KB828741 MS04-012: Cumulative Update for Microsoft RPC/DCOM
> > Microsoft KB835732 MS04-011: Security Update for Microsoft Windows
> > Microsoft KB837009 MS04-013: Cumulative Security Update for Outlook
> Express
> > Microsoft KB831167: Wininet retries POST requests with a blank header.
> >
> > ...via SUS. The server has been averaging three unscheduled reboots per
> day
> > since. If anyone has any ideas, I would be most grateful. We have had
> little
> > luck analyzing the dump file. My guess is that it has something to do
with
> > the RPC/DCOM patch, since it is serving data for several third party web
> and
> > windows client applications.
> >
> > Thanks,
> > John
> >
> >
>|||Nope, Microsoft is not taking editorial license on this or any other post
that isn't spam, pornography, personal attacks, or something else nasty like
that.
I can see both your original post (Message-ID:
<esSncLKKEHA.2884@.TK2MSFTNGP12.phx.gbl>) and Mark's followup (Message-ID:
<uigrjjQKEHA.3944@.tk2msftngp13.phx.gbl>) on msnews.microsoft.com using
Outlook Express. I can also see them using our web newsreader at:
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=April+security+patches&dg=microsoft.public.sqlserver.server&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
news:Ow6KCQ5KEHA.240@.TK2MSFTNGP10.phx.gbl...
> Mark,
> Thanks, for the response. I guess it is time to use up one of our MSDN
> support calls. This set of patches has significantly reduced the
> availability of two servers that had been running with no problems for
> months, and of course, since it includes the RPC/DCOM patch, we cannot
> remove the patch since this is an exploit that requires no I/O (inadequate
> operator) action.
> Curious though that neither my original post or your response displayed in
> the newsgroup. I only found your response, by searching the forum for the
> subject line of my post. Is Microsoft taking editorial license?
> Cheers,
> John
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:uigrjjQKEHA.3944@.tk2msftngp13.phx.gbl...
> > I don't know how to solve your issue, but I would recommend you call
> > Microsoft Product Support Services (MS PSS).
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> >
> >
> >
> > "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
> > news:esSncLKKEHA.2884@.TK2MSFTNGP12.phx.gbl...
> > > We are running SQL Server 2000/sp3a on a relatively new server sized
to
> > meet
> > > our needs for the foreseeable future. The OS is Win2k/sp4. It has
been
> > > running very well since installed; the last reboot was over a month
ago
> > and
> > > that was scheduled for security updates.
> > >
> > > On Monday evening, we installed the April security patches:
> > >
> > > Microsoft KB837001 MS04-014:Vulnerability in Microsoft Jet Database
> Engine
> > > could permit code execution
> > > Microsoft KB828741 MS04-012: Cumulative Update for Microsoft RPC/DCOM
> > > Microsoft KB835732 MS04-011: Security Update for Microsoft Windows
> > > Microsoft KB837009 MS04-013: Cumulative Security Update for Outlook
> > Express
> > > Microsoft KB831167: Wininet retries POST requests with a blank header.
> > >
> > > ...via SUS. The server has been averaging three unscheduled reboots
per
> > day
> > > since. If anyone has any ideas, I would be most grateful. We have had
> > little
> > > luck analyzing the dump file. My guess is that it has something to do
> with
> > > the RPC/DCOM patch, since it is serving data for several third party
web
> > and
> > > windows client applications.
> > >
> > > Thanks,
> > > John
> > >
> > >
> >
> >
>|||Stephen,
Well, yesterday, both were not listed in my default reader, Outlook Express,
and searching only brought up the reply. Today, the search found Mark's
response, my followup and your followup. Looking down the list, I do not
find my original post of 4/22. Just reporting what I see.
Are there any known problems with this patch?
We immediately saw unscheduled reboots of our SQL Server (2000sp/3a running
on Win2k Server sp4). Typically these are network related, and I have not
seen anything untoward happening when running perfmon and sql profiler
against the server, but they began almost immediately after the sus push of
these patches to the server.
We also experienced problems with a third party web application trying to
access the database server. This application is running on a Windows
2000/sp4 server running IIS5.0 with SSL. The application reported numerous
connection failures to the database. SQL Profiler did show any failed login
attempts, so I have to assume that it was the applications data tier that
was having the problem; but again, the problem did not exist until the
patches were applied.
Removing the patches resolved the issue, but clearly this is not a situation
I want to maintain for any length of time.
Regards,
John
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23aUwOT7KEHA.3052@.TK2MSFTNGP12.phx.gbl...
> Nope, Microsoft is not taking editorial license on this or any other post
> that isn't spam, pornography, personal attacks, or something else nasty
like
> that.
> I can see both your original post (Message-ID:
> <esSncLKKEHA.2884@.TK2MSFTNGP12.phx.gbl>) and Mark's followup (Message-ID:
> <uigrjjQKEHA.3944@.tk2msftngp13.phx.gbl>) on msnews.microsoft.com using
> Outlook Express. I can also see them using our web newsreader at:
>
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=April+security+patches&dg=microsoft.public.sqlserver.server&cat=&la
ng=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
> news:Ow6KCQ5KEHA.240@.TK2MSFTNGP10.phx.gbl...
> > Mark,
> >
> > Thanks, for the response. I guess it is time to use up one of our MSDN
> > support calls. This set of patches has significantly reduced the
> > availability of two servers that had been running with no problems for
> > months, and of course, since it includes the RPC/DCOM patch, we cannot
> > remove the patch since this is an exploit that requires no I/O
(inadequate
> > operator) action.
> >
> > Curious though that neither my original post or your response displayed
in
> > the newsgroup. I only found your response, by searching the forum for
the
> > subject line of my post. Is Microsoft taking editorial license?
> >
> > Cheers,
> > John
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:uigrjjQKEHA.3944@.tk2msftngp13.phx.gbl...
> > > I don't know how to solve your issue, but I would recommend you call
> > > Microsoft Product Support Services (MS PSS).
> > >
> > > --
> > > Mark Allison, SQL Server MVP
> > > http://www.markallison.co.uk
> > >
> > >
> > >
> > >
> > > "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
> > > news:esSncLKKEHA.2884@.TK2MSFTNGP12.phx.gbl...
> > > > We are running SQL Server 2000/sp3a on a relatively new server sized
> to
> > > meet
> > > > our needs for the foreseeable future. The OS is Win2k/sp4. It has
> been
> > > > running very well since installed; the last reboot was over a month
> ago
> > > and
> > > > that was scheduled for security updates.
> > > >
> > > > On Monday evening, we installed the April security patches:
> > > >
> > > > Microsoft KB837001 MS04-014:Vulnerability in Microsoft Jet Database
> > Engine
> > > > could permit code execution
> > > > Microsoft KB828741 MS04-012: Cumulative Update for Microsoft
RPC/DCOM
> > > > Microsoft KB835732 MS04-011: Security Update for Microsoft Windows
> > > > Microsoft KB837009 MS04-013: Cumulative Security Update for Outlook
> > > Express
> > > > Microsoft KB831167: Wininet retries POST requests with a blank
header.
> > > >
> > > > ...via SUS. The server has been averaging three unscheduled reboots
> per
> > > day
> > > > since. If anyone has any ideas, I would be most grateful. We have
had
> > > little
> > > > luck analyzing the dump file. My guess is that it has something to
do
> > with
> > > > the RPC/DCOM patch, since it is serving data for several third party
> web
> > > and
> > > > windows client applications.
> > > >
> > > > Thanks,
> > > > John
> > > >
> > > >
> > >
> > >
> >
> >
>|||I'll just repeat what Mark said and suggest that you open up a case with PSS
to track down your problems with the patch. I'm sorry, but while I work in
PSS, I don't work on the support team and can't help you.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
news:ukKS0RGLEHA.808@.tk2msftngp13.phx.gbl...
> Stephen,
> Well, yesterday, both were not listed in my default reader, Outlook
Express,
> and searching only brought up the reply. Today, the search found Mark's
> response, my followup and your followup. Looking down the list, I do not
> find my original post of 4/22. Just reporting what I see.
> Are there any known problems with this patch?
> We immediately saw unscheduled reboots of our SQL Server (2000sp/3a
running
> on Win2k Server sp4). Typically these are network related, and I have not
> seen anything untoward happening when running perfmon and sql profiler
> against the server, but they began almost immediately after the sus push
of
> these patches to the server.
> We also experienced problems with a third party web application trying to
> access the database server. This application is running on a Windows
> 2000/sp4 server running IIS5.0 with SSL. The application reported numerous
> connection failures to the database. SQL Profiler did show any failed
login
> attempts, so I have to assume that it was the applications data tier that
> was having the problem; but again, the problem did not exist until the
> patches were applied.
> Removing the patches resolved the issue, but clearly this is not a
situation
> I want to maintain for any length of time.
> Regards,
> John
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23aUwOT7KEHA.3052@.TK2MSFTNGP12.phx.gbl...
> > Nope, Microsoft is not taking editorial license on this or any other
post
> > that isn't spam, pornography, personal attacks, or something else nasty
> like
> > that.
> >
> > I can see both your original post (Message-ID:
> > <esSncLKKEHA.2884@.TK2MSFTNGP12.phx.gbl>) and Mark's followup
(Message-ID:
> > <uigrjjQKEHA.3944@.tk2msftngp13.phx.gbl>) on msnews.microsoft.com using
> > Outlook Express. I can also see them using our web newsreader at:
> >
> >
>
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=April+security+patches&dg=microsoft.public.sqlserver.server&cat=&la
>
ng=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=> >
> > --
> > Sincerely,
> > Stephen Dybing
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
> > news:Ow6KCQ5KEHA.240@.TK2MSFTNGP10.phx.gbl...
> > > Mark,
> > >
> > > Thanks, for the response. I guess it is time to use up one of our MSDN
> > > support calls. This set of patches has significantly reduced the
> > > availability of two servers that had been running with no problems for
> > > months, and of course, since it includes the RPC/DCOM patch, we cannot
> > > remove the patch since this is an exploit that requires no I/O
> (inadequate
> > > operator) action.
> > >
> > > Curious though that neither my original post or your response
displayed
> in
> > > the newsgroup. I only found your response, by searching the forum for
> the
> > > subject line of my post. Is Microsoft taking editorial license?
> > >
> > > Cheers,
> > > John
> > >
> > > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > > news:uigrjjQKEHA.3944@.tk2msftngp13.phx.gbl...
> > > > I don't know how to solve your issue, but I would recommend you call
> > > > Microsoft Product Support Services (MS PSS).
> > > >
> > > > --
> > > > Mark Allison, SQL Server MVP
> > > > http://www.markallison.co.uk
> > > >
> > > >
> > > >
> > > >
> > > > "John" <jkraeck@.NOprincetonSPAM.edu> wrote in message
> > > > news:esSncLKKEHA.2884@.TK2MSFTNGP12.phx.gbl...
> > > > > We are running SQL Server 2000/sp3a on a relatively new server
sized
> > to
> > > > meet
> > > > > our needs for the foreseeable future. The OS is Win2k/sp4. It has
> > been
> > > > > running very well since installed; the last reboot was over a
month
> > ago
> > > > and
> > > > > that was scheduled for security updates.
> > > > >
> > > > > On Monday evening, we installed the April security patches:
> > > > >
> > > > > Microsoft KB837001 MS04-014:Vulnerability in Microsoft Jet
Database
> > > Engine
> > > > > could permit code execution
> > > > > Microsoft KB828741 MS04-012: Cumulative Update for Microsoft
> RPC/DCOM
> > > > > Microsoft KB835732 MS04-011: Security Update for Microsoft Windows
> > > > > Microsoft KB837009 MS04-013: Cumulative Security Update for
Outlook
> > > > Express
> > > > > Microsoft KB831167: Wininet retries POST requests with a blank
> header.
> > > > >
> > > > > ...via SUS. The server has been averaging three unscheduled
reboots
> > per
> > > > day
> > > > > since. If anyone has any ideas, I would be most grateful. We have
> had
> > > > little
> > > > > luck analyzing the dump file. My guess is that it has something to
> do
> > > with
> > > > > the RPC/DCOM patch, since it is serving data for several third
party
> > web
> > > > and
> > > > > windows client applications.
> > > > >
> > > > > Thanks,
> > > > > John
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||We applied MS04-011 835732 and had 2 lockups/blue screens in 24 hours.
Last night we applied MS03-031 Cumulative Patch for Microsoft SQL Server (815495);
So far, it has been up 15 hours without re-booting.
Tim Ssql

Tuesday, March 20, 2012

Applying SP4. Do you have to provide sa password?

I have never applied a service pack to sql server 2000. Someone tells me that you have an option of supplying the SA password but do not have to and the service pack is applied just as if you did supply the SA password. This sounds odd to me. So, is it true? I am asking because our server instance shows "SP4" but a fix that was supposed to be included in SP4 was apparently not as the problem persists (link from sql server 2005 to 2000 fails when referenced in sql2005). I was thinking that whoever ran the service pack may not have provided the SA password so some of the SP4 was not applied?

Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "s-1". The provider supports the interface, but returns a failure code when it is used.

Thanks.

The service pack ask for the password, It allows to continue without a password, and it provides a notice about the dangers of so doing.

So yes, the service pack may have been properly applied without a password -IF the sa account did not have a password.

|||

There are two ways to log into a SQL Server. One is by specifing a login and password, such as the "sa" login. The other is by using the Windows Creditentials which the user has logged into the operating system with. When installing the service pack you have the option of logging in with which ever method you would like to; either the "sa" account or the Windows account.

What command is being performed when this error comes up?

|||

The above errors arise when trying to issue a select statement on the 2005 server which references tables on the 2000 server which it is linked to. I thought perhaps the person who applied the service pack 4 may not have done it correctly. I was not there, and have never done it myself. The message may imply missing components.

ex. On 2005 server: Select * From linked2000server.mydb.dbo.mytable

|||

Can you query any tables over the linked server, or is this one the only one causing the problem?

If it's every table a sp4 reinstall may be in order on the SQL 2000 server.

|||Nope!

Applying SP4. Do you have to provide sa password?

Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "s-1". The provider supports the interface, but returns a failure code when it is used.

Thanks.

The service pack ask for the password, It allows to continue without a password, and it provides a notice about the dangers of so doing.

So yes, the service pack may have been properly applied without a password -IF the sa account did not have a password.

|||

What command is being performed when this error comes up?

|||

ex. On 2005 server: Select * From linked2000server.mydb.dbo.mytable

|||

Can you query any tables over the linked server, or is this one the only one causing the problem?

If it's every table a sp4 reinstall may be in order on the SQL 2000 server.

|||Nope!sql

Applying sp4 to ss2000

When trying to upgrade to ss2005 the install program said that I needed to
install sp3 before upgrade. I can't find sp3 anywhere but I have sp4 with
my msdn disks. When I try to apply sp4 it says that "another operation has
left pending files and I need to restart my computer. I restart my computer
and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
then I got tired of trying and quit.
Does anyone know how to get around the little catch 22?
Thanks,
TCheck out:
http://support.microsoft.com/kb/817362/en-us
Hope this helps.
Dan Guzman
SQL Server MVP
"Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
news:e8qnSf1hGHA.3588@.TK2MSFTNGP02.phx.gbl...
> When trying to upgrade to ss2005 the install program said that I needed to
> install sp3 before upgrade. I can't find sp3 anywhere but I have sp4 with
> my msdn disks. When I try to apply sp4 it says that "another operation
> has left pending files and I need to restart my computer. I restart my
> computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> then I got tired of trying and quit.
>
> Does anyone know how to get around the little catch 22?
> Thanks,
> T
>

Applying sp4 to ss2000

Applying SP4 on Replicated databases

Hi,
We have transactional replication with 30 subscribers. We are planning to
upgrade to sp4 from sp3a. Publisher and distributor are in the same server.
So is there any order(sequence) like first we have to upgrade publisher and
then subscriber...
Is there any known issues/impact on publisher or subscriber.
Thanks in advance for your help.
Thanks
Prabhu
The rule is
Local Distributor - upgrade the publisher/distributor first then the
subscribers
Remote Distributor - upgrade the distributor, then the publisher, and
finally the subscriber(s).
"Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
news:B7770777-C2B2-4E30-9F13-354A18A3666E@.microsoft.com...
> Hi,
> We have transactional replication with 30 subscribers. We are planning to
> upgrade to sp4 from sp3a. Publisher and distributor are in the same
> server.
> So is there any order(sequence) like first we have to upgrade publisher
> and
> then subscriber...
> Is there any known issues/impact on publisher or subscriber.
> Thanks in advance for your help.
> Thanks
> Prabhu
>
|||Thanks cotter,
So we don't need to worry about the subscriber type, whether its read-only
or updatable subscriber. Am i right ? or is there any difference for these
types.
Thanks
Prabhu
"Hilary Cotter" wrote:

> The rule is
> Local Distributor - upgrade the publisher/distributor first then the
> subscribers
> Remote Distributor - upgrade the distributor, then the publisher, and
> finally the subscriber(s).
> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
> news:B7770777-C2B2-4E30-9F13-354A18A3666E@.microsoft.com...
>
>
|||Yes you don't have to worry about the subscribers. Just do them last.
I always shut down the SQL Server agents on the boxes before doing the
upgrades. You will need to notify your users that you are doing upgrades so
you can kick them off.
Hilary
"Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
news:EC578700-3B73-4C38-9255-4FA97C79A7B4@.microsoft.com...[vbcol=seagreen]
> Thanks cotter,
> So we don't need to worry about the subscriber type, whether its
> read-only
> or updatable subscriber. Am i right ? or is there any difference for these
> types.
> Thanks
> Prabhu
>
>
> "Hilary Cotter" wrote:

Applying SP4 on an active/passive 2 way cluster

I have a 2 way cluster and I want to apply SP4 on it.
Basically, I have 2 servers. Server A runs a default instance and
another instance. While the default services is disabled and the other
instance is running, Server B runs the default instance and has the other
instance disabled. This basically acts like a 2 way cluster
(active/passive).
How can I apply SQL Server 2000 SP4 on the 2 servers and have all the
nodes come up the correct way? What are the steps to achieve this?http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-
C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||This is not going to help me. I have explicitly mentioned that I have a 2
way cluster in my original email. So a standard article like you have given
me is NOT going to help.
"Ole Kristian Bangås" <olekristian.bangas@.masterminds.no> wrote in message
news:Xns981DB671F914Folekristianbangaas@.207.46.248.16...
> http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-
> C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
> --
> Ole Kristian Bangås
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"Shiva" <arbitsquare@.hotmail.com> wrote in
news:OTKiIkivGHA.2120@.TK2MSFTNGP03.phx.gbl:
> This is not going to help me. I have explicitly mentioned that I have
> a 2 way cluster in my original email. So a standard article like you
> have given me is NOT going to help.
Yes, and I don't quite get the problem. Let me quote point two in the
article I gave a link to:
"Run the service pack from the node that owns the group containing the
virtual server that you plan to upgrade. This installs the service pack
files on all nodes in the failover cluster."
Can you please explain what your problem is? As I understand your scenario
you have a two-node two-instance active-passive SQL cluster. An upgrade of
that cluster should be rather straightforward.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"Shiva" <arbitsquare@.hotmail.com> wrote in
news:OTKiIkivGHA.2120@.TK2MSFTNGP03.phx.gbl:
Correction to my previous post, You actually have an active/active
confuguration, with one instance on each server, but the upgrade procedure
is still valid.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP

Applying SP4 on an active/passive 2 way cluster

I have a 2 way cluster and I want to apply SP4 on it.

Basically, I have 2 servers. Server A runs a default instance and another instance. While the default services is disabled and the other instance is running, Server B runs the default instance and has the other instance disabled. This basically acts like a 2 way cluster (active/passive).

How can I apply SQL Server 2000 SP4 on the 2 servers and have all the nodes come up the correct way? What are the steps to achieve this?Since SQL Server is a shared resource on a clustered server, installing SP4 on one server is automatically done on the other. Everything is transparent to the user/admin.sql

Applying SP4 on an active/passive 2 way cluster

I have a 2 way cluster and I want to apply SP4 on it.
Basically, I have 2 servers. Server A runs a default instance and
another instance. While the default services is disabled and the other
instance is running, Server B runs the default instance and has the other
instance disabled. This basically acts like a 2 way cluster
(active/passive).
How can I apply SQL Server 2000 SP4 on the 2 servers and have all the
nodes come up the correct way? What are the steps to achieve this?http://download.microsoft.com/downl...584E-4DE0-B36F-
C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||This is not going to help me. I have explicitly mentioned that I have a 2
way cluster in my original email. So a standard article like you have given
me is NOT going to help.
"Ole Kristian Bangs" <olekristian.bangas@.masterminds.no> wrote in message
news:Xns981DB671F914Folekristianbangaas@.
207.46.248.16...
> http://download.microsoft.com/downl...584E-4DE0-B36F-
> C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
> --
> Ole Kristian Bangs
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"Shiva" <arbitsquare@.hotmail.com> wrote in
news:OTKiIkivGHA.2120@.TK2MSFTNGP03.phx.gbl:

> This is not going to help me. I have explicitly mentioned that I have
> a 2 way cluster in my original email. So a standard article like you
> have given me is NOT going to help.
Yes, and I don't quite get the problem. Let me quote point two in the
article I gave a link to:
"Run the service pack from the node that owns the group containing the
virtual server that you plan to upgrade. This installs the service pack
files on all nodes in the failover cluster."
Can you please explain what your problem is? As I understand your scenario
you have a two-node two-instance active-passive SQL cluster. An upgrade of
that cluster should be rather straightforward.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"Shiva" <arbitsquare@.hotmail.com> wrote in
news:OTKiIkivGHA.2120@.TK2MSFTNGP03.phx.gbl:
Correction to my previous post, You actually have an active/active
confuguration, with one instance on each server, but the upgrade procedure
is still valid.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
applied together, one before the other, not at all?
Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:

> Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
> applied together, one before the other, not at all?
> --
>
|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>

Monday, March 19, 2012

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should b
e
applied together, one before the other, not at all?
--Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:

> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
be
> applied together, one before the other, not at all?
> --
>|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
applied together, one before the other, not at all?
--Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
> applied together, one before the other, not at all?
> --
>|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>

Applying SP4

Hi,
I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
This Test Server will be made the new Production Server. I have to apply SP4
to the Test server. Do I -
First apply SP4 to the test server and then Backup system and user databases
on Production Server and restore them on the Test Server or
Do a Backup of system and user databases on Production Server, restore them
on test server and then apply SP4 on the test server?
Will there be a issue after restore on the test server as it has SP3 and the
Production Server has SP2?
Is Backup and restore a better way here in comparison to detach and attach
database?
ThanksThat all depends, what is your goal?
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:11FCCE2A-19D0-4B26-8B71-107FB518A1AA@.microsoft.com...
> Hi,
> I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
> and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
> This Test Server will be made the new Production Server. I have to apply
> SP4
> to the Test server. Do I -
> First apply SP4 to the test server and then Backup system and user
> databases
> on Production Server and restore them on the Test Server or
> Do a Backup of system and user databases on Production Server, restore
> them
> on test server and then apply SP4 on the test server?
> Will there be a issue after restore on the test server as it has SP3 and
> the
> Production Server has SP2?
> Is Backup and restore a better way here in comparison to detach and attach
> database?
> Thanks
>
>|||Thanks for the response. My goal is to promote the Test Server to a Full
Production Server running SQL Server 2000 (SP4)
"Aaron Bertrand [SQL Server MVP]" wrote:
> That all depends, what is your goal?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:11FCCE2A-19D0-4B26-8B71-107FB518A1AA@.microsoft.com...
> > Hi,
> >
> > I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
> > and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
> >
> > This Test Server will be made the new Production Server. I have to apply
> > SP4
> > to the Test server. Do I -
> >
> > First apply SP4 to the test server and then Backup system and user
> > databases
> > on Production Server and restore them on the Test Server or
> > Do a Backup of system and user databases on Production Server, restore
> > them
> > on test server and then apply SP4 on the test server?
> > Will there be a issue after restore on the test server as it has SP3 and
> > the
> > Production Server has SP2?
> >
> > Is Backup and restore a better way here in comparison to detach and attach
> > database?
> >
> > Thanks
> >
> >
> >
> >
>
>|||Hi
"sharman" wrote:
> Hi,
> I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
> and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
> This Test Server will be made the new Production Server. I have to apply SP4
> to the Test server. Do I -
> First apply SP4 to the test server and then Backup system and user databases
> on Production Server and restore them on the Test Server or
> Do a Backup of system and user databases on Production Server, restore them
> on test server and then apply SP4 on the test server?
> Will there be a issue after restore on the test server as it has SP3 and the
> Production Server has SP2?
> Is Backup and restore a better way here in comparison to detach and attach
> database?
> Thanks
Although I don't think you will have a any major problems with the migration
from SP2 to SP4 (plus hotfixes) the safest way would be to upgrade the test
server and test you application, then backup the databases, upgrade the
production server to the same level before backing up the database again and
migrating them.
John|||> Thanks for the response. My goal is to promote the Test Server to a Full
> Production Server running SQL Server 2000 (SP4)
With the exact same databases on it?
I would upgrade production to SP4, take the backups, then apply SP4 to test,
and then restore the backups.
Remember to get the 2040 hotfix (and maybe even the 2187 cumulative hotfix)
if you are using AWE.|||This would help me understand Service Packs. If I apply SP4 to Test server
and then migrate databases from Production Server (running SP2) (both system
and user databases) to the Test Server,would it undo the changes done by SP4
on Test Server?
If I migrate system and user databases from Production to Test Server and
then apply SP4 to Test Server and test it. After successful testing I just
migrate the user databases to the test server, would it undo the changes done
by SP4 on Test Server?
"John Bell" wrote:
> Hi
> "sharman" wrote:
> > Hi,
> >
> > I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
> > and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
> >
> > This Test Server will be made the new Production Server. I have to apply SP4
> > to the Test server. Do I -
> >
> > First apply SP4 to the test server and then Backup system and user databases
> > on Production Server and restore them on the Test Server or
> > Do a Backup of system and user databases on Production Server, restore them
> > on test server and then apply SP4 on the test server?
> > Will there be a issue after restore on the test server as it has SP3 and the
> > Production Server has SP2?
> >
> > Is Backup and restore a better way here in comparison to detach and attach
> > database?
> >
> > Thanks
> Although I don't think you will have a any major problems with the migration
> from SP2 to SP4 (plus hotfixes) the safest way would be to upgrade the test
> server and test you application, then backup the databases, upgrade the
> production server to the same level before backing up the database again and
> migrating them.
> John|||Hi
"sharman" wrote:
> This would help me understand Service Packs. If I apply SP4 to Test server
> and then migrate databases from Production Server (running SP2) (both system
> and user databases) to the Test Server,would it undo the changes done by SP4
> on Test Server?
> If I migrate system and user databases from Production to Test Server and
> then apply SP4 to Test Server and test it. After successful testing I just
> migrate the user databases to the test server, would it undo the changes done
> by SP4 on Test Server?
>
The exact changes to a database made by a release or hotfix is not usually
made available to people outside MS, although I guess you could raise an
incident to ask. Even if the database files are compatible, if you tested on
one version the behaviour of your application will not necessarily be the
same when run on a different version, therefore invalidating your tests. It
is therefore best to upgrade in such a way as everything is in step.
HTH
John

Applying SP4

Hi,
I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
This Test Server will be made the new Production Server. I have to apply SP4
to the Test server. Do I -
First apply SP4 to the test server and then Backup system and user databases
on Production Server and restore them on the Test Server or
Do a Backup of system and user databases on Production Server, restore them
on test server and then apply SP4 on the test server?
Will there be a issue after restore on the test server as it has SP3 and the
Production Server has SP2?
Is Backup and restore a better way here in comparison to detach and attach
database?
Thanks
That all depends, what is your goal?
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:11FCCE2A-19D0-4B26-8B71-107FB518A1AA@.microsoft.com...
> Hi,
> I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
> and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
> This Test Server will be made the new Production Server. I have to apply
> SP4
> to the Test server. Do I -
> First apply SP4 to the test server and then Backup system and user
> databases
> on Production Server and restore them on the Test Server or
> Do a Backup of system and user databases on Production Server, restore
> them
> on test server and then apply SP4 on the test server?
> Will there be a issue after restore on the test server as it has SP3 and
> the
> Production Server has SP2?
> Is Backup and restore a better way here in comparison to detach and attach
> database?
> Thanks
>
>
|||Thanks for the response. My goal is to promote the Test Server to a Full
Production Server running SQL Server 2000 (SP4)
"Aaron Bertrand [SQL Server MVP]" wrote:

> That all depends, what is your goal?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:11FCCE2A-19D0-4B26-8B71-107FB518A1AA@.microsoft.com...
>
>
|||Hi
"sharman" wrote:

> Hi,
> I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
> and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
> This Test Server will be made the new Production Server. I have to apply SP4
> to the Test server. Do I -
> First apply SP4 to the test server and then Backup system and user databases
> on Production Server and restore them on the Test Server or
> Do a Backup of system and user databases on Production Server, restore them
> on test server and then apply SP4 on the test server?
> Will there be a issue after restore on the test server as it has SP3 and the
> Production Server has SP2?
> Is Backup and restore a better way here in comparison to detach and attach
> database?
> Thanks
Although I don't think you will have a any major problems with the migration
from SP2 to SP4 (plus hotfixes) the safest way would be to upgrade the test
server and test you application, then backup the databases, upgrade the
production server to the same level before backing up the database again and
migrating them.
John
|||> Thanks for the response. My goal is to promote the Test Server to a Full
> Production Server running SQL Server 2000 (SP4)
With the exact same databases on it?
I would upgrade production to SP4, take the backups, then apply SP4 to test,
and then restore the backups.
Remember to get the 2040 hotfix (and maybe even the 2187 cumulative hotfix)
if you are using AWE.
|||This would help me understand Service Packs. If I apply SP4 to Test server
and then migrate databases from Production Server (running SP2) (both system
and user databases) to the Test Server,would it undo the changes done by SP4
on Test Server?
If I migrate system and user databases from Production to Test Server and
then apply SP4 to Test Server and test it. After successful testing I just
migrate the user databases to the test server, would it undo the changes done
by SP4 on Test Server?
"John Bell" wrote:

> Hi
> "sharman" wrote:
>
> Although I don't think you will have a any major problems with the migration
> from SP2 to SP4 (plus hotfixes) the safest way would be to upgrade the test
> server and test you application, then backup the databases, upgrade the
> production server to the same level before backing up the database again and
> migrating them.
> John
|||Hi
"sharman" wrote:

> This would help me understand Service Packs. If I apply SP4 to Test server
> and then migrate databases from Production Server (running SP2) (both system
> and user databases) to the Test Server,would it undo the changes done by SP4
> on Test Server?
> If I migrate system and user databases from Production to Test Server and
> then apply SP4 to Test Server and test it. After successful testing I just
> migrate the user databases to the test server, would it undo the changes done
> by SP4 on Test Server?
>
The exact changes to a database made by a release or hotfix is not usually
made available to people outside MS, although I guess you could raise an
incident to ask. Even if the database files are compatible, if you tested on
one version the behaviour of your application will not necessarily be the
same when run on a different version, therefore invalidating your tests. It
is therefore best to upgrade in such a way as everything is in step.
HTH
John

Applying SP4

Hi,
I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
This Test Server will be made the new Production Server. I have to apply SP4
to the Test server. Do I -
First apply SP4 to the test server and then Backup system and user databases
on Production Server and restore them on the Test Server or
Do a Backup of system and user databases on Production Server, restore them
on test server and then apply SP4 on the test server?
Will there be a issue after restore on the test server as it has SP3 and the
Production Server has SP2?
Is Backup and restore a better way here in comparison to detach and attach
database?
ThanksThat all depends, what is your goal?
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:11FCCE2A-19D0-4B26-8B71-107FB518A1AA@.microsoft.com...
> Hi,
> I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
> and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
> This Test Server will be made the new Production Server. I have to apply
> SP4
> to the Test server. Do I -
> First apply SP4 to the test server and then Backup system and user
> databases
> on Production Server and restore them on the Test Server or
> Do a Backup of system and user databases on Production Server, restore
> them
> on test server and then apply SP4 on the test server?
> Will there be a issue after restore on the test server as it has SP3 and
> the
> Production Server has SP2?
> Is Backup and restore a better way here in comparison to detach and attach
> database?
> Thanks
>
>|||Thanks for the response. My goal is to promote the Test Server to a Full
Production Server running SQL Server 2000 (SP4)
"Aaron Bertrand [SQL Server MVP]" wrote:

> That all depends, what is your goal?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:11FCCE2A-19D0-4B26-8B71-107FB518A1AA@.microsoft.com...
>
>|||Hi
"sharman" wrote:

> Hi,
> I have a Production Server - Windows 2000 Server, SQL Server 2000 (SP2)
> and a Test server - Windows 2003 Server, SQL Server 2000 (SP3).
> This Test Server will be made the new Production Server. I have to apply S
P4
> to the Test server. Do I -
> First apply SP4 to the test server and then Backup system and user databas
es
> on Production Server and restore them on the Test Server or
> Do a Backup of system and user databases on Production Server, restore the
m
> on test server and then apply SP4 on the test server?
> Will there be a issue after restore on the test server as it has SP3 and t
he
> Production Server has SP2?
> Is Backup and restore a better way here in comparison to detach and attach
> database?
> Thanks
Although I don't think you will have a any major problems with the migration
from SP2 to SP4 (plus hotfixes) the safest way would be to upgrade the test
server and test you application, then backup the databases, upgrade the
production server to the same level before backing up the database again and
migrating them.
John|||> Thanks for the response. My goal is to promote the Test Server to a Full
> Production Server running SQL Server 2000 (SP4)
With the exact same databases on it?
I would upgrade production to SP4, take the backups, then apply SP4 to test,
and then restore the backups.
Remember to get the 2040 hotfix (and maybe even the 2187 cumulative hotfix)
if you are using AWE.|||This would help me understand Service Packs. If I apply SP4 to Test server
and then migrate databases from Production Server (running SP2) (both system
and user databases) to the Test Server,would it undo the changes done by SP4
on Test Server?
If I migrate system and user databases from Production to Test Server and
then apply SP4 to Test Server and test it. After successful testing I just
migrate the user databases to the test server, would it undo the changes don
e
by SP4 on Test Server?
"John Bell" wrote:

> Hi
> "sharman" wrote:
>
> Although I don't think you will have a any major problems with the migrati
on
> from SP2 to SP4 (plus hotfixes) the safest way would be to upgrade the tes
t
> server and test you application, then backup the databases, upgrade the
> production server to the same level before backing up the database again a
nd
> migrating them.
> John|||Hi
"sharman" wrote:

> This would help me understand Service Packs. If I apply SP4 to Test server
> and then migrate databases from Production Server (running SP2) (both syst
em
> and user databases) to the Test Server,would it undo the changes done by S
P4
> on Test Server?
> If I migrate system and user databases from Production to Test Server and
> then apply SP4 to Test Server and test it. After successful testing I just
> migrate the user databases to the test server, would it undo the changes d
one
> by SP4 on Test Server?
>
The exact changes to a database made by a release or hotfix is not usually
made available to people outside MS, although I guess you could raise an
incident to ask. Even if the database files are compatible, if you tested o
n
one version the behaviour of your application will not necessarily be the
same when run on a different version, therefore invalidating your tests. It
is therefore best to upgrade in such a way as everything is in step.
HTH
John

Applying SP to Log-shipping Standby server

Scenario: SQL2000 server that is the Standby server in a log-shipping scenario

The need: Apply SP4 to the standby server

Issue: Service pack installation wants all databases to be "writable". The databases on the standby server are "IsInStandby" state and cannot be made "writable" (non-Read-Only) by the Alter Database command.

Question: is there a way to alter the state so that I can apply the service pack without removing log-shiping, applying the sp and then reestablishing log-shipping?

ReadmeSql2k32sp4.htm:

http://download.microsoft.com/download/1/b/d/1bdf5b78-584e-4de0-b36f-c44e06b0d2a3/ReadmeSql2k32sp4.htm#_1462462_considerations_for_an_instance_i_gq59

Sunday, March 11, 2012

Applying 2003 SP1 to a SQL Cluster running SP3

Are there any known problems applying 2003 SP1 to a 2003 Active/Passive SQL
Cluster running SQL SP3, not 3a? We have seen enough posts about SQL SP4
issues that we want to wait.We did just this on Saturday and it has been a nightmare. Everything was
running fine with Windows 2003 and SQL2000 SP3 but installing W2K3 SP1 has
wreaked havoc!
Our overall performance has dropped dramatically. What used to take 2
seconds to run now takes upwards of 6. We've been working with Microsoft and
they have absolutely no idea what the problem is and haven't really offered
much in terms of troubleshooting ideas either.
One suggestion we've heard is to update statictics on all tables (which I am
doing right now) but it doesn't seem to make a difference.
Of course Microsoft says that all of this should work fine and that W2K3 SP1
and SQL 2000 SP3 should co-exist fine in a cluster...
Good luck!
"JGTKD" wrote:
> Are there any known problems applying 2003 SP1 to a 2003 Active/Passive SQL
> Cluster running SQL SP3, not 3a? We have seen enough posts about SQL SP4
> issues that we want to wait.|||Any updates on this thread? I am looking to do the same thing (sp1 on 2003
Enterprise Server running mssql2000 sp3) in the near future.
Thanks.
"Drinian" wrote:
> We did just this on Saturday and it has been a nightmare. Everything was
> running fine with Windows 2003 and SQL2000 SP3 but installing W2K3 SP1 has
> wreaked havoc!
> Our overall performance has dropped dramatically. What used to take 2
> seconds to run now takes upwards of 6. We've been working with Microsoft and
> they have absolutely no idea what the problem is and haven't really offered
> much in terms of troubleshooting ideas either.
> One suggestion we've heard is to update statictics on all tables (which I am
> doing right now) but it doesn't seem to make a difference.
> Of course Microsoft says that all of this should work fine and that W2K3 SP1
> and SQL 2000 SP3 should co-exist fine in a cluster...
> Good luck!
> "JGTKD" wrote:
> > Are there any known problems applying 2003 SP1 to a 2003 Active/Passive SQL
> > Cluster running SQL SP3, not 3a? We have seen enough posts about SQL SP4
> > issues that we want to wait.

Apply sql2k post sp4 fix 2162 on cluster

I applied sql2k post sp4 fix 2040 and 2162 on active node of the cluster without error, the version number is 8.00.2162. When failover the cluster and double check version number again, it's 8.00.2040. That means fix 2162 didn't push to passive node. So I tried apply fix 2162 on current active node but stopped with KB904660(ENU) setup error: An error in updating your system has occurred. Can't find any log file, and OS is win2k3 enterprise edition with sp1. Anyone got similar issue?

You should get a higher build of Hotfix package. The issue you are reporting is a known bug and has been fixed in later builds.

thanks

Raja

Information on this page is posted as is and no warranty as to the accuracy of any of the presented information

Thursday, March 22, 2012

April Security Patches and SQL Server

April Security Patches and SQL Server

April Security Patches and SQL Server

Tuesday, March 20, 2012

Applying SP4. Do you have to provide sa password?

Applying SP4. Do you have to provide sa password?

Applying sp4 to ss2000

Applying sp4 to ss2000

Applying SP4 on Replicated databases

Applying SP4 on an active/passive 2 way cluster

Applying SP4 on an active/passive 2 way cluster

Applying SP4 on an active/passive 2 way cluster

Applying sp4 advice on a server with sql and analysis services

Monday, March 19, 2012

Applying sp4 advice on a server with sql and analysis services

Applying sp4 advice on a server with sql and analysis services

Applying SP4

Applying SP4

Applying SP4

Applying SP to Log-shipping Standby server

Sunday, March 11, 2012

Applying 2003 SP1 to a SQL Cluster running SP3

Apply sql2k post sp4 fix 2162 on cluster

sql server tools

Blog Archive

About Me