http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx MohammedU. Moderator SQL-Server-Performance.com
Hi Mohammed, Have you installed SP2 on your dev or test machine and found any new bugs? Or Have you noticed any performance hits etc? Please let me know your inputs.
Not yet... I installed CTP on my laptop but not RTM... MohammedU. Moderator SQL-Server-Performance.com
I applied SP2 on my production server and it was straight forward... one suggestion is that.. don't try to install it from Network... copy the file locally and install... from network installation there are some error reported in MSDN.... After installation, Database engine service required to be restarted... I followed the below mentioned steps (a) Stopped all the sql server 2005 services from Configuration Manager ((i have downtime and i just stopped all the services as precaution) (b) Installed SP2 (c) Restarted the services (d) SQL Server version after the installation is 9.00.3042.00 Madhu
I just applied sp2 on an active SQL2005 DevEdt sp1 dev server (db/as/rs) without user connections. Install went fine.[^] No issues in logs or sql-errorlog. Reboot was needed.[V] Install took 25 minutes for this desktop (P4) with 1Gb ram. Until now, no issues detected. [8D]
Good to see the positive responses. I am yet to see someone complaining about SP 2 installation. Guess that the product team has done a good job this time. Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
Yes there were lot of suggestions, rants, fixes under Microsoft Connect site since the SP2 CTP has been released, I believe still there are lot to be fixed which are under way. There is no end of such requirement as long as the product is stable you can expect them soon. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Here is the official list of fixed bugs http://support.microsoft.com/?kbid=921896 Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
I've implemented 5 (dev/QA) sql2005 StdEdtn sp1 to sp2 without any issues until now.[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />I've also implemented it for a clustered X64 EE test instance without an issue. The plant was not running production today, it was planned downtime. The other 3 (prod) instances were up and running, but offcourse without connections because we took e.g. biztalk offline. Just in case [^]<br /><br />The upgrade went very smooth [8D] and took +- 35 minutes to complete (for both nodes).<br />It is very strange. Unlike with the original install, where you could also follow the install at the second node, now it just states it is waiting for the install on the second node to complete. Eventvwr and the installlogs are the place to be.<br /><br />Fingers crossed [|)]<br /><br />btw: I 've tried to avoid reboots on the dev-servers, shutting off all services the "inventory" showed, still it needed a reboot for one the XML installation. [?][?]
Also check the latest changes or issues with Maintenance plans after SP2: http://sqlserver-qa.net/blogs/sqlto...ntenance-plan-changes-since-sql-2005-sp2.aspx Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
I came to know that Microsoft releasing SP2 Hotfix for SQL Server 2005.... MohammedU. Moderator SQL-Server-Performance.com
Critical Update for SQL Server 2005 Service Pack 2 (KB:93350<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br /<a target="_blank" href=http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en>http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en</a><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com
the sp2-downloads have been updated to include the fix. The hotfix should only be applied to already installed sp2-s http://support.microsoft.com/kb/933508
No arises the question: What to do on a cluster when one instance already has SP2 ? - continue all instances with sp2 + the hotfix - continue the other instances with the refreshed sp2 ???
MS did just confirm to me that just applying the refreshed sp2 will work and will not cause issues to the allready upgraded instance. (I will have to apply the hotfix to the allready upgraded instance)
"Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available" check ms-download again for it athttp://support.microsoft.com/?kbid=933097
SP2 - Check Database Task on Maint only ever does master http://sqlblogcasts.com/blogs/tonyr...base-task-on-maint-only-ever-does-master.aspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Critical Update for SQL Server 2005 Service Pack 2 http://www.microsoft.com/downloads/...FE-35A7-4BB2-8E73-932770099711&displaylang=en Quick Details Version: 09.00.3159.00 Knowledge Base (KB) Articles: KB934459 Date Published: 4/3/2007 Overview In SQL Server 2005 SP2, the Maintenance Plan "Check Database Integrity" and "Execute T-SQL" Tasks can lose database context under certain circumstances. If configured to check integrity on multiple databases, the Check Integrity Task repeatedly checks the default database. If an Execute T-SQL Task contains multiple batches, separated by GO statements, and does not include USE statements in each batch, those statements that don't provide a database name will be executed against the default database. Incorrect operation can be verified by setting up a profiler trace and observing the database column. Elaborated a bit athttp://blogs.msdn.com/psssql/archiv...-2005-service-pack-2-sp2-fixes-explained.aspx Posted by alzdba MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
