Re: Can't Install SP4 for SQL 2000 / Win2k3

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It should, but the way things go you can never rely on that fact :)

--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"hamm3r" <hammer@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:TzWGe.13774$Kx6.1958@xxxxxxxxxxx
> Thanks for the tips. I'll try this on Monday.
>
> Another (simple?) question to throw out there though...
>
> Shouldn't unstalling and reinstalling SQL2000 result in a pristine msdb
> database?
>
>
> "Vikram Vamshi" <vikram.vamshi@xxxxxxxxxxxxxxxxxxx> wrote in message
> news:OyuLk3IlFHA.3256@xxxxxxxxxxxxxxxxxxxxxxx
>> Looks like your msdb database has been marked as suspect.
>> You need to fix this problem before you can go ahead with the service
>> pack installation.
>>
>> Try this
>> 1. use sp_resetstatus to reset the status of msdb.
>> 2. stop and start sql server service
>> 3. if the msdb database again becomes suspect, look at the most recen
>> errorlog, it will give you a clue to why msdb is being set to suspect.
>> hth
>> --
>> Vikram Vamshi
>> Database Engineer
>> Eclipsys Corporation
>> "hamm3r" <hammer@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:X_NFe.692$6%2.494@xxxxxxxxxxx
>>> Vikram,
>>>
>>> Thanks for helping out.
>>>
>>> The contents were shown in the original post:
>>>
>>> "And the C:\temp\1\sqlsp.out shows:
>>>
>>> Database 'msdb' cannot be opened. It has been marked SUSPECT by
>>> recovery.
>>> See the SQL Server errorlog for more information."
>>>
>>> This message exists both before and after the uninstall and
>>> reinstallation of SQL 2000.
>>>
>>> "Vikram Vamshi" <vikram.vamshi@xxxxxxxxxxxxxxxxxxx> wrote in message
>>> news:udkuoEskFHA.2852@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Can you post the contents of c:\temp\1\sqlsp.out?
>>>> That should give us a clue to what went wrong
>>>>
>>>> --
>>>> Vikram Vamshi
>>>> Database Engineer
>>>> Eclipsys Corporation
>>>> "hamm3r" <hammer@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>>> news:p6NFe.677$6%2.601@xxxxxxxxxxx
>>>>>I am attempting to update SQL 2000 Server (RTM) to SP4 on Windows 2003
>>>>>Server Standard w/ SP1
>>>>>
>>>>> After extracting SQL2000-KB884525-SP4-x86-ENU.EXE to C:\SQL2KSP4 and
>>>>> running setup.bat, the installation hangs at "Validating User. Please
>>>>> Wait" but then ceases (the install window disappears) with no
>>>>> errors/dialogue boxes.
>>>>>
>>>>> After reading up on this I changed the TEMP and TMP environmental
>>>>> variables so they have no spaces in them.
>>>>>
>>>>> The end of my sqlsp.log shows:
>>>>>
>>>>> 10:36:39 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:EMEXTSRV -n -d master -o
>>>>> "c:\temp\1\sqlsp.out" -Q"Exit(declare @ret int if (select count(*)
>>>>> from msdb.dbo.systargetservers) = 0 Set @ret=0 else Set @ret=403
>>>>> elect )" -E
>>>>> 10:36:39 Process Exit Code: (-100)
>>>>> 10:36:39 Error : While detecting required SP3 warnings.
>>>>> 10:36:39 End Action DialogShowSdUpgrade
>>>>> 10:36:39 End: ShowDialogs()
>>>>> 10:36:39 Action CleanUpInstall:
>>>>> 10:36:39 Installation Failed.
>>>>>
>>>>> And the C:\temp\1\sqlsp.out shows:
>>>>>
>>>>> Database 'msdb' cannot be opened. It has been marked SUSPECT by
>>>>> recovery. See the SQL Server errorlog for more information.
>>>>>
>>>>> Since the database is not in production and since I have minimal
>>>>> SQL2000 admin experience, I uninstalled SQL 2000 and deleted the
>>>>> C:\Program Files\SQL Server directory, rebooted, and reinstalled SQL
>>>>> 2000.
>>>>>
>>>>> Despite my efforts, the SP4 installation still fails in an identical
>>>>> fashion as prior to my reinstallation of SQL 2000.
>>>>>
>>>>> I have also tried installing SP3 and get the same errors.
>>>>>
>>>>> I can't seem to find any relevant solutions in the MSKB or in
>>>>> dejanews.Com on this.
>>>>>
>>>>> Can anybody help this lost soul?
>>>>>
>>>>> TIA!
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Cant Install SP4 for SQL 2000 / Win2k3
    ... This explains why a reinstall did not fix the errors. ... ran 'sp_resetstatus msdb' from query analyzer, ... > The LSN %S_LSN passed to log scan in database '%.*ls' is invalid. ... > To resolve this problem, obtain the latest service pack for Microsoft SQL ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant Install SP4 for SQL 2000 / Win2k3
    ... Looks like your msdb database has been marked as suspect. ... > See the SQL Server errorlog for more information." ...
    (microsoft.public.sqlserver.setup)
  • Re: MSDB (Subspect)
    ... I have one more suggestion to this issue, I feel that during the MSDB mdf ... and LDF physical file copy (cold Backup), they would have started the SQL ... Stop & Start the SQL Server ... > Probably because the database was damaged when you took the backup. ...
    (microsoft.public.sqlserver.server)
  • Re: Cant Install SP4 for SQL 2000 / Win2k3
    ... The LSN %S_LSN passed to log scan in database '%.*ls' is invalid. ... For row in sysdatabases for database 'msdb', the status bit 256 was forced ... Recovery complete. ... nets the same "suspect" msdb... ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant Install SP4 for SQL 2000 / Win2k3
    ... Shouldn't unstalling and reinstalling SQL2000 result in a pristine msdb ... > Looks like your msdb database has been marked as suspect. ...
    (microsoft.public.sqlserver.setup)