I recently came across two interesting blog post by PSS SQL Server Engineers. They have written two interesting SQL Server 2008 related post and it can be very helpful to those who come across the issues mentioned in them.
Rarely but sometime there is need to rebuilding the System Databases. In SQL Server 2008 there is no facility to rebuild only msdb database. All the system database have to be rebuilt if any of the database has to be rebuild. System Databases like mssqlsystemresource can be rebuilt only by running Repair from the Installation Center.
SQL Server 2008 documentation have mentioned that users will have option to rename the ‘sa’ username during installation or upgrade but infect that is not true. If user have renamed ‘sa’ username due to security purpose, upgrading SQL Server 2008 may not be successful. This article discuss the whole issue in depth.
Reference : Pinal Dave (http://blog.SQLAuthority.com)