SQL 7 SP3 Hotfix stuffup, is reapplication okay? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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)

SQL 7 SP3 Hotfix stuffup, is reapplication okay?

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-13 : 08:14:29

Steve Morris writes "So I think we stuffed up our SP3 application.

The MSDTC, MSSQLServer, SQServerAgent were not stopped before starting setup.

The guy who installed it thinks that internally the processes should stop the required services. But then why is it in the docs?

Anyway, there was a particular fix we thought would solve a db locking problem we have been experiencing (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q247871), yet even tho our version is now 7.00.9** the problem lingers.

So, suspecting the install is bad, we'd like to reinstall. However, its on production so need to know if anyone knows of any problems with reapplying the SP3.

Additionally, it is a DTC fix, but the sqlsp.log file says the DTC is not modified.

<..snip..>
08:32:39 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
08:32:39 C:\TEMP\_ISTMP7.DIR\cldtcstp.exe -SupportDir "C:\TEMP\_ISTMP7.DIR\" -DTCPkg "J:\General Service Packs\SQL Server\70SP3\X86\Other\dtcsetup.exe" -LogFile "C:\TEMP\sqlsp.log"
2/10/2002 8:32:39 J:\General Service Packs\SQL Server\70SP3\X86\Other\dtcsetup.exe, file version: 66519040,262215
C:\WINNT\System32\dtcsetup.exe, file version: 66519040,262215
2/10/2002 8:32:39 J:\General Service Packs\SQL Server\70SP3\X86\Other\dtcsetup.exe, file timestamp: 799897856,29281889
C:\WINNT\System32\dtcsetup.exe, file timestamp: -1864807808,29281897
2/10/2002 8:32:39 The DTC setup executable is already up to date.
<..snip..>

Any help?

~Steve"

chadmat
The Chadinator

1974 Posts

Posted - 2002-02-13 : 11:55:10

Did the install complete? Does sqlsp.log say
'installation succeeded'?

The SP installation should stop the services for you. How do you know that this is the problem you are having? There are many causes of blocking.

If you want to reapply SP3, I would first confirm that the original failed (It will say in the sqlsp.log) if so, then just rerun it, and note any errors you get.

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources