Upgrading service pack issue - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Upgrading service pack issue

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-05-07 : 05:19:45

Hi,

I was trying to upgrade SQL Server 2005 Standard Edition with service pack 2 but I am getting below message

Process Name: MSSQLSERVER Locked files found. A reboot will be required if processes are not closed.
Process Name: MSSQLSERVEROLAPService Locked files found. A reboot will be required if processes are not closed.
Process Name: MsDtsServer Locked files found. A reboot will be required if processes are not closed.

Twice I restart server but same message I am getting

any expert opinion plz

T.I.A

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-07 : 05:45:39

Have you installed the service pack? All that means is that the server will have to be rebooted after the installation completes. If that's not a problem (uptime requirements) then don't worry.

--
Gail Shaw

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-05-07 : 05:56:55

Hi,

Yes for select @@version I m getting

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-07 : 06:15:38

Looks like it installed fine.
Microsoft SQL Server 2005 - 9.00.3042.00

Version 9.00.3042 is SP2

--
Gail Shaw

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-05-07 : 07:27:57

Hi,

But with same service pack which installed on another server gives me

select @@version
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Why it is like that????

Issue is getting that message and i m stucked there....

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-07 : 10:47:30

3054 - means you applied hotfix after applying SP2

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-07 : 13:53:33

And the reference to Service pack 1/Service pack 2 in the message is referring to the version of the windows operating system, not SQL.

Your SP2 patch has installed successfully. No need to worry.
On the 2nd server, someone's installed one of the post-SP2 hotfixes/cumulative updates.

--
Gail Shaw

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-07 : 13:59:52

Oh, and a service pack won't ever downgrade the version. So if the second server was already on build 3054 when you went to install service pack 2, the installation would run, but it wouldn't actually do anything, because the sql version is already higher than the one you're installing.

--
Gail Shaw

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources