This topic has been reported for inappropriate content
November 23, 2019 at 4:19 am
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 10:00 am
This was removed by the editor as SPAM
November 23, 2019 at 10:11 am
This was removed by the editor as SPAM
November 23, 2019 at 12:11 pm
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
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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply