SQL Service Pack Upgrade

[khampariamukesh]

Hello Team,

I am aware of that we should be updated with the latest Patch in SQL Server. But I have not found anywhere whether we can upgrade directly

Source	Target
SQL Server 2005 Service Pack 2 9.00.3042 SQL Server 2005 SP2	SQL Server 2005 SP 4 9.00.5292 SQL Server 2005 SP4 + Q2494123

Do you think there is any pre-requisite to check.. Any Note which says, yes it is possible.?

Thanks

Mukesh

[former_member188883 · Accepted solution]

Hi Mukesh,

Please refer below SAP note to get all relevant information on MSSQL service packs.

62988 - Service packs for MS SQL Server

Regards,

Deepak Kori

[khampariamukesh · Accepted solution]

Hi Deepak,

Thanks for your reply.

I have seen this Snote in the start of the question, it is itself not saying whether we can upgrade to SQL 2005 SP2 to SQL 2005 SP4. Also what are the pre-requisite for this..

Thanks

Mukesh

[former_member188883 · Accepted solution]

Hi Mukesh,

Service packs can be updated directly. Refer below SAP note for pre-requisites and steps for applying the updates.

985137 - Service Pack Installation for SQL Server 2005

Regards,

Deepak Kori

[khampariamukesh · Accepted solution]

Thanks Deepak, I had seen this SNote as well but missed to read one line that was needed by me

Thank you.

Keep Helping.

Reg

Mukesh

[hasanajsh]

Microsoft says Yes. It is Cumulative.