SQLAuthority News – Upgrade SQL Server With SA Renamed – Rebuild System Databases – SQL Server 2008

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)

Previous Post
SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download
Next Post
SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems

Related Posts

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.


  • Hi Pinal,

    your response is awaited on this.


Leave a Reply