Post reply

system databases owned by SA account

  • January 27, 2014 at 3:46 am

    #287732

    Hi

    I have disabled the sa account on one of our servers. I noticed that the system databases are owned by this account so I was wondering if there would be any negative effects on the server after doing this. All seems to be ok at the moment but would this effect anything such as the ability to restore any of these databases should the situation arise ? Should I change the database owner to our domain service account which has sys admin access ?

  • January 27, 2014 at 3:51 am

    #1683474

    No and no.

    Disabling the account just means that it cannot be used to log in to the server. That's it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 27, 2014 at 3:56 am

    #1683475

    Ok. Thank you.

    🙂

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply