1.Backup Permissions
--User/Batch id should have db_backupoperator role or SysAdmin role
2.Restore Permissions
-- User/Batch id should have dbcreator role or SysAdmin
-- Or If the user/Batch id Administror privileges on windows server, then can restore databases without
'SysAdmin' or 'dbcreator' roles.
--User/Batch id should have db_backupoperator role or SysAdmin role
2.Restore Permissions
-- User/Batch id should have dbcreator role or SysAdmin
-- Or If the user/Batch id Administror privileges on windows server, then can restore databases without
'SysAdmin' or 'dbcreator' roles.
No comments:
Post a Comment