Re: sp4 to sp1 to sp4

timperkins,

I don't specifically know your problem, but FWIW, your build number says
that your SQL Server is at SP4.
http://support.microsoft.com/kb/889543

7.00.1063 = SQL Server 7.0 SP4

The (Build 2195: Service Pack 4) refers to the version of Windows NT 5.0,
just in case that seemed confusing.

RLF

"timperkins" <timperkins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EE021C3A-340C-4C66-BE06-9309C9A45EA4@xxxxxxxxxxxxxxxx
select @@version yields:

Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86)
Apr 9 2002 14:18:16
Copyright (c) 1988-2002 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

But when I try to rerun the SP4 patch, the install program says:

"Setup has detected that the previous install attempt was not completed.
Press Retry to continue installation or Cancel to exit setup."

Retry goes through a dialog "Setup is upgrading your server..." but then
responds with:

"RETRYING - Running script sp1.sql (1 of 8) : Retried 1 time(s)"

It finally just craps out and doesn't complete. Should i just ignore the
reinstall problem? Reboot the server (haven't tried that yet)?

Yes, I'd love to upgrade but we're running a legacy app that doesn't work
beyond 7.0... We have MSSQL 2005 running on a different server.



"Aaron Bertrand [SQL Server MVP]" wrote:

What does SELECT @@VERSION say?

Have you considered upgrading to a version that is still supported, or at
least to a version that the people at Microsoft still remember? :-)


On 5/28/08 9:29 PM, in article
06B49D59-2287-4E52-AF61-13F10CA6E82F@xxxxxxxxxxxxx, "timperkins"
<timperkins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

It's a long story, but I have a legacy SQL7 Enterprise server that I
recently
installed, patched to SP4 and have been running for a few days (working
great, thanks).

Tonight, I inadvertently started the SP1 install. The script failed,
but to
be safe I tried running the sp4 install again. It is failing now as
well.
The server appears to be running properly, but I'm uneasy leaving it in
this
state.

Looking for some advise as to how to proceed and make sure that the
host is
truly up to SP4 patch level.




.

Relevant Pages

  • Re: Confusion Kaspersky requirements
    ... SP4 causes BSODs in some computers. ... Upgrading The ... Upgrading The Base or SP3 install to SP4 causes a BSOD ...
    (alt.comp.anti-virus)
  • Installing Exchange System Management tools..
    ... I want to install the Blackberry Enterprise Server on one of our Windows ... As requested by RIM I have installed the Exchange System Management tools on ... my current Exchange Service Pack level is at SP4 (if I ...
    (microsoft.public.exchange.admin)
  • Re: msde to sql2000
    ... Upgrading from WMSDE (the version of MSDE you get with a default WSS ... SQL Server 2K SP3a) is all you need to do and everything you have in WMSDE ... server farm version of the install rather than the default. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: 811493 repeatedly
    ... Oct. (we are using a SUS server) In Feb. we started ... getting daily messages saying to install 811493 again. ... We have resorted to installing SP4 ... > Microsoft Windows XP Professional ...
    (microsoft.public.win2000.windows_update)
  • Re: Dell server needs windows 2000 server sp4
    ... You should be able to integrate this into your Win2k Server source files and ... create a CD which will install with the same product key: ... Dell says we need to install using Windows Server 2000 sp4. ... We called Microsoft and were told they no longer support win2k server ...
    (microsoft.public.windows.server.setup)
Quantcast