August 21, 2009 at 9:32 am
I have installed SQL server 2005 SP3 on test clustered system. The installation went fine without any problems. Log shows that SP3 installed successfully. Also when I see in Add remove programs it shows SP3 installed. But when I checked the version in SQL it still shows SP2 build 3315 which is cu 12 I beleive. also wanted to know if there is command line arguments I can to install SP3 through command line.
thanks
Suresh
August 21, 2009 at 10:37 am
Have you installed SP3 on both the nodes?
August 21, 2009 at 10:53 am
Just on one node for the time being. I hadn't rebooted it. So it got fixed after I rebooted it. Thanks for prompt response Ravi.
August 21, 2009 at 11:14 am
How are you verifying that the instance you are connected to was in fact upgraded to SP3? Do you have multiple instances on that cluster?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 21, 2009 at 1:49 pm
I just have one instance and I did verify the version and build on that instance.
August 21, 2009 at 1:50 pm
I ran following on that instance
select serverproperty('productversion'), serverproperty ('productlevel'), serverproperty ('edition')
and executed the query.
August 21, 2009 at 2:01 pm
When you ran the service pack - it should have listed everything that it was going to upgrade. Rerun the service pack upgrade and verify that all items in that list have been upgraded. When you select the item, it should tell you whether or not it can be upgraded.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 21, 2009 at 2:21 pm
Is this 64 bit or 32 bit SQL instance, I know we patched a 64 bit instance by mistake with 32 bit SP3 and it installed fine and all the logs stated so, but SQL was reporting SP2 still, did some head scratching and figured it out, worth a look?
Andrew
August 21, 2009 at 3:28 pm
Try this tip I wrote from experience:
http://www.mssqltips.com/tip.asp?tip=1668
God Bless,
ThomasLL
Thomas LeBlanc, MVP Data Platform Consultant
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply