Experience applying SP4 to SQL 2005?

15 pts.
Tags:
Database Instances
SQL 2005
SQL Server 2005
SQL Server database
SQL Server multiple instances
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I would to this is the same way as I would do it with Service Pack 3: http://www.db-staff.com/index.php/microsoft-sql-server/87-upgrade-sql-2005-cluster-to-sp3 But... If I do this and things go wrong, I can not uninstall the Service Pack 4... Do you have any experience regarding Service Pack 4? And do you have any proposal to what I can do? Kind regards, Carl-Marius

Software/Hardware used:
MSSQL 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

The SQL Server service packs are usually applied to the server and it can easily tell what version of the softwares are running by either issuing a T-SQL command or by SQL Server Management Studio / SQL Server Enterprise Manager. Needless to say, the client tools also need to be updated to ensure the latest release and also to ensure that all features still work properly. May be there are older versions that will not work properly.
The install process works similar way as server updates while u want to apply the service pack or SP, Remember, here is only need to update the client tools which should be the only option when installing the service pack update. Also take the all latest backups before doing the job. For better <a href=”http://support.microsoft.com/kb/913089″>concept and helpful guide is here</a>.

Kindly keep me update !

Hope it helps u !

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • CarlMarius
    Hi Rechil, Thank you for your answer, I made a full database backup and system backup, before I applied the Service Pack 4. I did not encounter any problems during the "upgrade" and everything continued to work fine after a reboot. Kind regards, Carl-Marius
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following