marrowyung
asked on
the right need to backup/restore /detach/attach database
Deer all,
please correct me if I am wrong, in MS SQL, only the login with the sysadmin role in SQL server can do the backup/restore/attach/deta ch of database?
please correct me if I am wrong, in MS SQL, only the login with the sysadmin role in SQL server can do the backup/restore/attach/deta
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The OP asked if it was correct - apart from dbcreator which states it can restore but doesn't state the others, he is correct in his question.
As I mentioned (and you did too), it's not necessarily a WISE decision to hand out elevated permissions, but that isn't what he asked.
As I mentioned (and you did too), it's not necessarily a WISE decision to hand out elevated permissions, but that isn't what he asked.
The question was can only the SA perform these tasks. The answer is no. Therefore incorrect :)
ASKER
what I mean is if it is only anyone with sysadmin role can do the DB backup and restore, is it?
all these has sysdamin role:
1)NT SERVICE\MSSQLSERVER
2) NT SERVICE\SQLSERVERAGENT
so I belive that if the sysadmin role removed from these account, SQL server is not going to operate, right?
all these has sysdamin role:
1)NT SERVICE\MSSQLSERVER
2) NT SERVICE\SQLSERVERAGENT
so I belive that if the sysadmin role removed from these account, SQL server is not going to operate, right?
ASKER
but the one who can assign/add/remove role must be sysadmin, right?
No. Please read the link that explains each role and what it does
Giving SA permissions unnecessarily is a dangerous game. The server/DB roles are there for this very reason.