SP2 failed only on the Database engine and now won't restart
I have a clean SQL 2005 Ent. x64 SP1 clean with no user db's.....applied SP2 and everything showed "Success" except the Database Services (Error 29534)......
Time: 02/22/2007 08:29:50.134
KB Number: KB921896
Machine: TORCA8
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x64 ENTERPRISE
Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x64 ENTERPRISE
Reporting Services (MSSQLSERVER) ENU SP1 9.00.2047.00 x64 ENTERPRISE
Notification Services ENU SP1 9.00.2047.00 x64 ENTERPRISE
Integration Services ENU SP1 9.00.2047.00 x64 ENTERPRISE
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 ENTERPRISE
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could not be started. Verify that you have sufficient privileges to start system services. The error code is (1067) The process terminated unexpectedly.
-
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 0
Error Description :
-
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 0
Error Description :
-
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 0
Error Description :
-
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
-
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 0
Error Description :
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
-
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29534
Now SQL Server service won't restart.....
2007-02-22 10:16:31.28 Server Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-02-22 10:16:31.28 Server (c) 2005 Microsoft Corporation.
2007-02-22 10:16:31.28 Server All rights reserved.
2007-02-22 10:16:31.28 Server Server process ID is 2056.
2007-02-22 10:16:31.28 Server Authentication mode is MIXED.
2007-02-22 10:16:31.28 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-02-22 10:16:31.28 Server This instance of SQL Server last reported using a process ID of 576 at 2/22/2007 10:16:15 AM (local) 2/22/2007 3:16:15 PM (UTC). This is an informational message only; no user action is required.
2007-02-22 10:16:31.28 Server Registry startup parameters:
2007-02-22 10:16:31.28 Server -d E:\SQLData\master.mdf
2007-02-22 10:16:31.28 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-02-22 10:16:31.28 Server -l F:\SQLLogs\mastlog.ldf
2007-02-22 10:16:31.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-02-22 10:16:31.28 Server Detected 4 CPUs. This is an informational message; no user action is required.
2007-02-22 10:16:31.28 Server Cannot use Large Page Extensions: lock memory privilege was not granted.
2007-02-22 10:16:31.40 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-02-22 10:16:31.42 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-02-22 10:16:31.50 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 36200, committed (KB): 104760, memory utilization: 34%.
2007-02-22 10:16:33.45 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-02-22 10:16:33.45 Server Database mirroring has been enabled on this instance of SQL Server.
2007-02-22 10:16:33.47 spid5s Starting up database 'master'.
2007-02-22 10:16:33.47 spid5s SQL Trace ID 1 was started by login "sa".
2007-02-22 10:16:33.48 spid5s Starting up database 'mssqlsystemresource'.
2007-02-22 10:16:33.48 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-02-22 10:16:33.48 spid5s Error: 5173, Severity: 16, State: 1.
2007-02-22 10:16:33.48 spid5s One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
2007-02-22 10:16:33.48 spid5s Error: 5173, Severity: 16, State: 1.
2007-02-22 10:16:33.48 spid5s One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
2007-02-22 10:16:33.48 spid5s Log file 'F:\SQLLogs\mssqlsystemresource.ldf' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.
2007-02-22 10:16:33.48 spid5s The log cannot be rebuilt when the primary file is read-only.
2007-02-22 10:16:33.48 spid5s Error: 945, Severity: 14, State: 2.
2007-02-22 10:16:33.48 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
2007-02-22 10:16:33.48 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Tried reinstalling SP 2 in quiet mode using sapwd parameter.....now everything is showing the correct SP2 version but SQL Server Service won't start.......anyone?
hgarrett wrote: