1.Backup
--User/Batch id should be db_backupoperator role or 'SysAdmin' role
2.Restore
--User/Batch id should be dbcreator role or 'SysAdmin' role
--Or If User/Batch id have administror privileges on windows server level,,then database can restore without dbcreator role or 'SysAdmin' role.
--User/Batch id should be db_backupoperator role or 'SysAdmin' role
2.Restore
--User/Batch id should be dbcreator role or 'SysAdmin' role
--Or If User/Batch id have administror privileges on windows server level,,then database can restore without dbcreator role or 'SysAdmin' role.
No comments:
Post a Comment