This topic has been reported for inappropriate content

Post reply

SQL 2016 SA account - Backup database

  • November 23, 2019 at 4:19 am

    #3700196

    Good Morning Colleagues

    I hope you are doing good . Regarding SQL server 2016 , Does the SA account has the permissions to backup database ?

    Best Regards

  • November 23, 2019 at 12:11 pm

    #3700231

    eng_ahmedas wrote:

    Good Morning Colleagues

    I hope you are doing good . Regarding SQL server 2016 , Does the SA account has the permissions to backup database ?

    Best Regards

    SA is the sysadmin account, full and highest privileged account.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • November 23, 2019 at 12:32 pm

    #3700238

    Good Afternoon Muthukkumaran

    Thx for your confirmation . Appreciate find my below comments and waiting for your confirmation for it:

    1. I think SA account can do also restore for the database . is that true ?

    2. My question related to SQL server 2016  and i got information from one of my colleagues that SA account @ SQL 2016 doesn't have unlimited permissions and cant do database back up and it needs to have db_backuuoperator role attached to it to be able to backup/restore . So kindly advice.

    Thx in advance.

     

    Best Regard

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

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