Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SP3 upgrade from SP2 failed, PLS HELP Expand / Collapse
Posted Thursday, April 21, 2011 9:04 AM


Group: General Forum Members
Last Login: Thursday, March 3, 2016 9:34 PM
Points: 175, Visits: 816
Hello guys,

we are planing to upgrade SP2 to SP3 for our production. so i first wanted to upgrade our development box but the MS SQL SERVICE upgrade fail . when i going in SSMS and check the version it says SP3 but in the summary.txt it is saying fail.

This is a sql server 2005 standard edition running sp2.
Below in the copy of the message in the Summary.txt

Product : Database Services (MSSQLSERVER)
Product Version (Previous): 4035
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]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.. To continue, correct the problem, and then run SQL Server Setup again.

Any help in this matter in greatly appreciated.

During my research i saw that some one mentioned to check the default database setting in sql properties. and if those folders and paths are avialable. which they are as i checked it before posting.
Post #1097057
Posted Thursday, April 21, 2011 4:42 PM


Group: General Forum Members
Last Login: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
was one of your databases in suspect mode before you started the upgrade? I think the error is quite explicit.

the database should still be marked suspect so fix that issue then rerun the upgrade


Post #1097288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse