Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

December 2008 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

December 2008 - Posts

Production version of SQL Server 2005 Service Pack 3 (SP3) is released

Ok, you have seen many blog posts out there asking for Service pack 3 for SQL Server 2005 (such as Are you ready for SP3 and SQL2005SP3_WorkStarted, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances.

The Official SQL Server News blog refers about SQL Server 2005 SP3 as:

  • Roll-up of Quick Fix Engineering (QFE) updates completed since SQL Server 2005 SP2, as well as fixes to critical issues reported through the SQL Server community. Per revised servicing strategy for SQL Server releases, SP3 does not introduce major new features.
  • Feature Pack for SQL Server 2005 SP3 has been refreshed along with this release.
  • SP3 can be used to upgrade from any previous instance of SQL Server 2005
  • For customers who will be upgrading from SQL Server 2005 SP2 CU#10 or SP2 CU#11, you will have to install the latest CU on SP3 after upgrading to SP3 release to get all the fixes.  

Here are the download links:

What you will observe with this is also an updated Books Online notification to download,  as we notified here on this SQL2005BOL download post.

Wait a Minute: (Until 11:00 hours GMT) the above links to download SQL2005 SP3 is not yet available, please check back here again for further update in this regard.

Ok here is the update the files to download Download SQL Server 2005 SP3 & Download SQL Server 2005 Express SP3  are available now, so make sure you test them on your Dev.Environment before applying on Production instances. (Kudos to the team that fixed this issue)

SQL Server 2000 to 2005 to 2008 Upgrade Technical Reference Guide

What is the most required task when a DBA required to perform upgrade from previous versions?

  • Complete understanding of the databases that are required to upgrade.
  • Technical reference of upgrade path from previous version to the current one.
  • Testing of all aspects of that upgrade tasks.
  • Documented information of upgrade path and processes.

2 of the above tasks are totally dependant on individual preferences such as understanding and documentation about their platform and procedures. It is obvious that everyone will be looking for a documented procedure in terms of how to perform the upgrade of SQL Server platform. In the previous cases such as Upgrade from SQL Server 7 to 2000 and 2000 to 2005 there were limited resources available on web and from Microsoft too.

In this case of Upgrading from SQL Server 2005 to 2008 I’m happy to see a  490-page document that covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. Not only this is intended to be add-on supplement for the SQL Server 2008 books online, which is an additional reference in any case whent such reference is required.

Most of it amuses me is the detailed explanation on the topics within that document, see what is referred on that download link:

  • Chapter 1 gives an overview of the technical issues and decisions that are involved in an upgrade to SQL Server 2008, as well as recommendations for planning and deploying an upgrade.
  • Chapter 2 addresses issues related to upgrading to SQL Server 2008 Management Tools.
  • Chapters 3 through 8 focus on upgrade issues for SQL Server relational databases.
  • Chapter 9 addresses upgrading to SQL Server 2008 Express.
  • Chapters 10 through 14 focus on upgrading to SQL Server 2008 Business Intelligence components: Analysis Services, Data Mining, Integration Services, and Reporting Services.
  • Chapter 15 addresses the implications of upgrading to SQL Server 2008 for other Microsoft applications and platforms.
  • Appendix 1 contains a table of allowed SQL Server 2008 version and edition upgrade paths.
  • Appendix 2 contains an upgrade planning checklist.

Good luck and don’t forget to refer each and every aspect of upgrade path and test them before you take it on the production environment.