RE: Installing SP4 on SQL 2000

Hmm normally it doesn't run in silent mode. I'll check when I get to work
tomorrow to see where the log files are. But for version information you can
type ..

SELECT @@Version

SQL Server 2000 SP4 is 8.00.2039.

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"David G" wrote:

An afterthought is, maybe the install happens silently and everything has run
and installed OK?
If that is the case, is there an @@ function that will confirm the Service
Pack Version that is installed?
--
Thanks
David G
Albury, Australia


"David G" wrote:

Hi Mohit,
I'm out of ideas, I've checked where you suggested (not exactly the same
path) and there are no log files. I'm trying to run sqlstp.exe from the
x386\setup folder but no luck, it seems to open but then nothing happens.
Maybe it won't matter if I just use SP3 version as I'm only using it on my PC
at home. (No network). Ideas appreciated.
--
Thanks
David G
Albury, Australia


"Mohit K. Gupta" wrote:

When you are installing the Patch for SQL Server it will check for the
services running, it will war you that the services are active and the files
are locked. But you do not have to shut down the services, infact if you do
some of the functionality of the patch can fail. Because most of the service
packs also apply database changes to the system databases (thus the backup
required!).

Another place to check for install log files is in C:\Program
Files\Microsoft SQL Server\80\Install\

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"David G" wrote:

Thanks,
I'm now wondering, should I have SQL Server on? I got the impression from
reading the Microsoft files that everything should be off, i.e. all SQL
Server stuff, I even turned off the Sql Server Service Manager in the system
tray on the right hand side of the task bar. Maybe I've got the wrong
impression.
I have checked for log files in c:\windows *.log and there are no files on
or around the time I started the install. It is still a mystery.
--
Thanks
David G
Albury, Australia


"Mohit K. Gupta" wrote:

Hi David,

Try going to the SETUP LOGS for the SP4, for SQL Server 2000 I believe
they are in C:\Windows\*.log files. Look at the files to see if the setup
was successful or there were issues.

If you can't find any log files, I would try to stop and start it again.
Also re-download the binaries from Microsoft just in case there is a
corruption issue.

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"David G" wrote:

Hi,
I'm a SQL Server newbie. I hope this is the right group. Basically I can't
get the SP4 after I've downloaded it, to run.

I've recently downloaded SP4 since I have reinstalled SQL Server 2000 which
I think is SP3. Anyway, I have downloaded the Database components exe file
and the Analysis services exe file. When I double click each file they
extract each group of components fine. The problem comes in trying to RUN
each of these.

Following the instructions from the MS web site I have run the Setup.bat
file and NOTHING seems to happen. I have run the setup.exe in the x86/setup
folder and it says setup is already running. Basically nothing seems to run
and indicate that it is actually installing. Now I'm worried something more
sinister has gone wrong. I know the MS Site has the instructions but they
seem awfully confusing or advanced or both. Is there a straight forward way
to do this? Could someone assist?

--
Thanks
David G
Albury, Australia
.

Relevant Pages

  • RE: Installing SP4 on SQL 2000
    ... tomorrow to see where the log files are. ... SQL Server 2000 SP4 is 8.00.2039. ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... Another place to check for install log files is in C:\Program ... MCITP: Database Administrator ... "David G" wrote: ... should I have SQL Server on? ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... maybe the install happens silently and everything has run ... "David G" wrote: ... Another place to check for install log files is in C:\Program ... should I have SQL Server on? ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... I'm willing to continue because I need this database to be up and working on ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • Re: Move or Setup of SQL Database toa Remote Server Fails
    ... Windows Server System MVP - SMS ... David Baur wrote: ... Could not verify SQL Server is clustered or not because the setup could not connect to the SQL Server 501ST or failed to run the query. ... The SCCM Primary Site Computer Account and the User account I am using are both sysadmin on the Remote SQL Server, and have sysadmin on Master as well. ...
    (microsoft.public.sms.setup)
Loading