Problems installing SP3/SP4 on SQL 7

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Problems installing SP3/SP4 on SQL 7

Author

Topic

sgtwilko
Starting Member

23 Posts

Posted - 2002-05-23 : 10:59:22

We have been trying to install SP3 or SP4 on SQL 7.

With both SP installs we get into the install and then we keep getting a
"A User database is read only, offline or suspect (not recovered)" error.

This stops the install.

Does anyone know anything about this error or how to get around it.

Thanks

--
Eagles may soar,
but Weasels aren't sucked into jet engines.

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-05-23 : 11:27:09

I guess somebody has to ask . . . are any of your user databases read only, offline or suspect? Cause if they are you need to make them not so the sp can make the changes it needs to.

<O>

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-05-23 : 11:30:51

posting the sqlsp.log file could be kinda helpful too.

Jeff Banschbach
Consultant, MCDBA

sgtwilko
Starting Member

23 Posts

Posted - 2002-05-23 : 11:52:19

quote:

I guess somebody has to ask . . . are any of your user databases read only, offline or suspect? Cause if they are you need to make them not so the sp can make the changes it needs to.

Not as far as we can tell.

They are all on-line, read/writeable and none are suspect (well the status code for being suspect (256) is not in the status column in the sysdatabases table, nor is 512 or 1024 (read only, offline)).

So we don't know what up...

--
Eagles may soar,
but Weasels aren't sucked into jet engines.

sgtwilko
Starting Member

23 Posts

Posted - 2002-05-23 : 11:54:54

quote:

posting the sqlsp.log file could be kinda helpful too.

Here are the last few lines.

If you want all of it, please say.


14:52:01 C:\TEMP\_ISTMP12.DIR\osql.exe  -n -d master -Q"exit" -Usa -P
14:52:01 Process Exit Code: (1) 
14:52:01 Password validated
14:52:01 End CheckPassword
14:52:01 Setup is starting service and verifying its state for an upgrade ...
14:52:01 C:\TEMP\_ISTMP12.DIR\scm.exe  -Silent 1 -Action 1 -Service MSSQLServer   -StartupOptions \-T4022 \-m
14:52:06 Process Exit Code: (0) 
14:52:11  C:\TEMP\_ISTMP12.DIR\osql.exe -Q"select count(name) from sysdatabases where ((status & 1024)!=0) or ((status & 512)!=0) or ((status & 256)!=0)" -o C:\TEMP\~sqldb0.txt -d master -E
14:52:11 Process Exit Code: (0) 
14:52:11 C:\TEMP\_ISTMP12.DIR\scm.exe  -Silent 1 -Action 6 -Service MSSQLServer  
14:52:31 Process Exit Code: (0) 
15:00:54 One or more of your user databases have been marked as read only, offline, or suspect (not recovered).  Correct the problem and restart setup.
15:00:54 Installation Failed.

I can confirm that the code that check for the types of database (select count(name) from sysdatabases where....) returns 0 so it should get past this issue...

Thanks again.

Ian
--
Eagles may soar,
but Weasels aren't sucked into jet engines.

Edited by - SgtWilko on 05/23/2002 11:57:10

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-05-23 : 16:43:46

When you run this select in QA it returns 0?

quote:
select count(name) from sysdatabases where ((status & 1024)!=0) or ((status & 512)!=0) or ((status & 256)!=0)

The error statement is indicating otherwise. Status is a bitmask type field so these values could be combined with other values, that's why they are using the bitwise operators in the select. Please verify that the above select returns a count of 0.

Jeff Banschbach
Consultant, MCDBA

chadmat
The Chadinator

1974 Posts

Posted - 2002-05-23 : 23:57:39

There are a few things that can cause this. Do you have any of the following installed?
- Crystal Reports
- Cold Fusion
- Solomon 4.0
- SMS 4.2

If so, Search the registry for SQLSRV32.DLL, and modify the paths so that all entries point to …..\WINNT\SYSTEM32.

If not, install MDAC 2.1 sp2 prior to applying the Service Pack.

If you still have no luck start the sp setup from the command line with the k=dbg switch

\X86\setup\setupsql.exe k=dbg

when prompted to manually verify databases are not read only, offline, or suspect choose yes, and continue with the install.

-Chad

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-05-24 : 14:26:27

You're my hero Chad... Some day I'm gonna know cool stuff like that too.