Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am considering applying this Service Pack 3 in a SQL Server 2008 with SP1, however I was not able to find if there are any drawbacks in this process, specially regarding to Replication Services and Reporting Services. Someone had done this update? It was smooth or got many issues?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

You shouldn't have any issues, just be sure that when you plan your maintenance for SQL Server you don't get blocked by the "Restart Computer" rule. E.g. if you have installed Windows Updates in the meantime you might not know that Windows needs to be restarted until you enter your maintenance window...

For some background, I got surprised by this during a SQL 2012 Service Pack + Cumulative Update series recently. It turned out that I fired up the computer, started the Service Pack install, but didn't know that Windows Update had started performing updates in the background. By the time I got to the CU, the reboot flag had been set, and I was very frustrated since it seemed to me like the SP install had forced a restart requirement.

http://www.sqlperformance.com/2012/12/system-configuration/sql-2012-slipstream

share|improve this answer
    
Many thanks for sharing Aaron! I'll keep this detail in mind! –  Willy Krawczyk Dec 17 '12 at 16:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.