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.
How to Rebuild System Databases in SQL Server 2008
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.
Upgrade for SQL Server 2008 can fail if you have renamed the ‘sa’ account
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 (https://blog.sqlauthority.com)
2 Comments. Leave new
Hi Pinal,
I am frequent visitor of you blog. Your solutions and articles really fascinates me.
I am in process of renaming all the “sa” accounts through out the environment. All SQL 2005 instances (clustered/standalone). I read SQL 2005 has ability to rename the “sa”.
Not very sure about the implication of renaming “sa” account but it appears not complex.
Could you please share your thoughts on “renaming ‘sa’ account in SQL 2005” once you have few minutes to spare?
Thanks in advance.
Cheers!
Avanish
Hi Pinal,
your response is awaited on this.