Microsoft SQL Server 需要特定使用者角色才能執行特定作業。如要在 SQL Server 資料庫上執行備份和 DR 擷取、還原、卸載、刪除和虛擬應用程式掛載作業，您必須為 Windows 使用者 (本機使用者或網域使用者) 提供憑證，該使用者必須具備足夠的 SQL 權限，才能執行該作業。
本節將詳細說明從備份/復原裝置執行擷取、還原、卸載、刪除和虛擬應用程式掛載作業所需的使用者角色。本節所列的建議角色是根據 Microsoft 針對存取 SQL Server 資料庫的最佳做法而定。
[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["上次更新時間：2025-06-16 (世界標準時間)。"],[[["Microsoft SQL Server operations like backup, restore, and mounting require a Windows user with specific SQL privileges."],["A Windows user with the `sysadmin` server role has all necessary permissions, but if this is deemed too liberal, the roles `dbcreator`, `db_backupoperator`, and `db_owner`, along with securables like \"View any database,\" \"Create any database,\" \"Alter any database,\" and \"Connect SQL\" are an alternative."],["Credentials for a Windows user with the appropriate roles are necessary when capturing database logs, restoring databases, or mounting a database as a virtual application."],["The Backup and DR agent must be installed using the credentials of a Microsoft Windows user who has sufficient privileges in the SQL environment."],["Improperly defined users or roles can lead to Backup and DR job failures, security violations, and potential data loss, so a qualified administrator must define them."]]],[]]
