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 (http://blog.SQLAuthority.com)

About these ads

2 thoughts on “SQLAuthority News – Upgrade SQL Server With SA Renamed – Rebuild System Databases – SQL Server 2008

  1. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s