使用 DPM 備份 SQL ServerBack up SQL Server with DPM

重要

已不再支援此版本的 Data Protection Manager (DPM),建議升級至 DPM 2019This version of Data Protection Manager (DPM) has reached the end of support, we recommend you to upgrade to DPM 2019.

System Center Data Protection Manager (DPM) 提供 SQL Server 資料庫的備份和復原。System Center Data Protection Manager (DPM) provides backup and recovery for SQL Server databases. 除了備份 SQL Server 資料庫,您還可以執行 SQL Server 電腦的系統備份或完整裸機備份。In addition to backing up SQL Server databases you can run a system backup or full bare-metal backup of the SQL Server computer. DPM 可以保護的內容︰Here's what DPM can protect:

  • 獨立 SQL Server 執行個體A standalone SQL Server instance

  • SQL Server 容錯移轉叢集執行個體 (FCI)A SQL Server Failover Cluster instance (FCI)

注意

DPM 2019 UR2 支援使用叢集共用磁碟區 (CSV) 的 SQL Server 容錯移轉叢集執行個體 (FCI)。DPM 2019 UR2 supports SQL Server Failover Cluster Instance (FCI) using Cluster Shared Volume (CSV).

此功能支援使用 Azure 上的儲存空間直接存取功能保護 SQL Server 容錯移轉叢集執行個體,以及使用 Azure 共用磁碟保護 SQL Server 容錯移轉叢集執行個體Protection of SQL server failover cluster instance with Storage Spaces Direct on Azure, and SQL server failover cluster instance with Azure shared disks is supported with this feature. 您必須在 Azure 虛擬機器中部署 DPM 伺服器,才能保護部署在 Azure VM 上的 SQL FCI 執行個體。The DPM server must be deployed in the Azure virtual machine to protect the SQL FCI instance, deployed on the Azure VMs.

  • 使用這些喜好設定的 SQL Server AlwaysOn 可用性群組:A SQL Server AlwaysOn availability group with theses preferences:

    • 慣用次要Prefer Secondary

    • 僅次要Secondary only

    • 主要Primary

    • 任何複本Any Replica

使用 DPM 備份 SQL Server 的原因Why back up SQL Server with DPM?

  • DPM 是為保護 SQL Server 進階設定所設計。DPM was designed to protect the advanced configurations of SQL Server.

  • 您可以將 DPM 保護 SQL Server 的頻率設為每 15 分鐘執行一次。DPM can be set to protect SQL Server as frequently as every 15 minutes.

  • DPM 可減少備份工具和 SQL Server 保護排程之間的潛在衝突。DPM reduces potential conflicts between backup tools and SQL Server protection schedules.

  • DPM 可在執行個體層級或資料庫層級保護 SQL Server。DPM can protect SQL Server at the instance level or the database level. 當執行個體層及的保護開啟時,DPM 會偵測該執行個體上的資料庫,然後自動將那些資料庫加入其保護群組。When protection at the instance level is turned on, DPM detects new databases on that instance and automatically adds them to its protection group.

  • DPM 是實惠的選擇。DPM is an affordable option. 不僅適用於小型 SQL Server 指紋,也可以為具有較大 SQL Server 指紋的組織調整規模。It's a good fit for a small SQL Server footprint and can scale for organizations that have a larger SQL Server footprint.

  • DPM 有自助式復原工具 (SSRT),可擴充資料庫系統管理員的選項,以進行 SQL 資料庫的自助式復原。DPM has a Self-Service Recovery Tool (SSRT) that extends database administrators' options for self-service recovery of SQL databases.

  • 如要升級到 SQL Server 2014,DPM 會在 SQL Server 升級之後,繼續備份已受保護的資料庫。If you're upgrading to SQL Server 2014 DPM will continue to back up already protected databases after the SQL Server upgrade. SQL Server 升級期間請儘量避免備份工作。You should avoid backup jobs during the SQL Server upgrade.

必要條件和限制Prerequisites and limitations

  • 如果您有一個資料庫上其檔案位於遠端的檔案共用,則保護將會失敗,錯誤識別碼為 104。If you have a database with files on a remote file share, protection will fail with Error ID 104. DPM 不支援保護遠端檔案共用上的 SQL Server 資料。DPM does not support protection for SQL Server data on a remote file share.

  • DPM 無法保護儲存在遠端 SMB 共用上的資料庫。DPM cannot protect databases that are stored on remote SMB shares.

  • 請確定可用性群組複本設定為唯讀Ensure that the availability group replicas are configured as read-only.

  • 您必須明確將系統帳戶 NTAuthority\System 新增到 SQL Server 上的 Sysadmin 群組。You must explicitly add the system account NTAuthority\System to the Sysadmin group on SQL Server.

  • 當您執行部分自主資料庫的替代位置復原時,請確定目標 SQL 執行個體已啟用自主資料庫功能。When you perform an alternate location recovery for a partially contained database, you must ensure that the target SQL instance has the Contained Databases feature enabled.

  • 當您執行檔案資料流資料庫的替代位置復原時,請確定目標 SQL 執行個體已啟用檔案資料流資料庫功能。When you perform an alternate location recovery for a file stream database, you must ensure that the target SQL instance has the file stream database feature enabled.

  • 保護 SQL Server AlwaysOn:Protection for SQL Server AlwaysOn:

    • DPM 在保護群組建立之際執行查詢時,會偵測可用性群組。DPM detects Availability Groups when running inquiry at protection group creation.

    • DPM 會偵測容錯移轉和資料庫的連續保護。DPM detects a failover and continues protection of the database.

    • DPM 支援 SQL Server 執行個體的多站台叢集設定。DPM supports multi-site cluster configurations for an instance of SQL Server.

    當您保護使用 AlwaysOn 功能的資料庫時,DPM 有下列限制:When you protect databases that use the AlwaysOn feature, DPM has the following limitations:

    • DPM 將會根據備份喜好設定,採用 SQL Server 中設定的可用性群組備份原則,如下所示:DPM will honor the backup policy for availability groups that is set in SQL Server based on the backup preferences, as follows:

      • 慣用次要:除非主要複本是唯一的線上複本,否則應在次要複本上執行備份。Prefer secondary - Backups should occur on a secondary replica except when the primary replica is the only replica online. 如果有多個次要複本可用,則將選擇使用備份優先順序最高的節點進行備份。If there are multiple secondary replicas available then the node with the highest backup priority will be selected for backup. 在只有主要複本可用的情況下,則應在主要複本上進行備份。In the case that only primary replica is available then backup should occur on the primary replica.

      • 僅次要:不應在主要複本上執行備份。Secondary only - Backup shouldn't be performed on the primary replica. 如果主要複本是唯一的線上複本,則不應進行備份。If the primary replica is the only one online, the backup shouldn't occur.

      • 主要備份:您應該一律在主要複本上進行備份。Primary - Backups should always occur on the primary replica.

      • 任何複本:備份可以在可用性群組中的任何可用性複本上執行。Any Replica - Backups can happen on any of the availability replicas in the availability group. 作為備份來源的節點將依據每個節點的備份優先順序而定。The node to be backed up from will be based on the backup priorities for each of the nodes.

    • 請注意:Note the following:

      • 備份的執行位置可以是任何可讀取的複本,即主要、同步次要、非同步次要等複本。Backups can happen from any readable replica i.e. primary, synchronous secondary, asynchronous secondary.

      • 若有任何複本已排除不予備份,例如已啟用 [排除複本] 或標示為無法讀取,則不論使用任何選項都不會選擇備份該複本。If any replica is excluded from backup, for example Exclude Replica is enabled or is marked as not readable, then that replica will not be selected for backup under any of the options.

      • 如果有多個複本可用且可讀取,則將選擇使用備份優先順序最高的節點進行備份。If multiple replicas are available and readable then the node with the highest backup priority will be selected for backup.

      • 如果在選取的節點上備份失敗,則備份操作便告失敗。If the backup fails on the selected node then the backup operation fails.

      • 不支援復原到原始位置。Recovery to the original location is not supported.

  • SQL Server 2014 或以上的備份問題:SQL Server 2014 or above backup issues:

開始之前Before you start

  1. 部署 DPM:確認已正確安裝與部署 DPM。Deploy DPM - Verify that DPM is installed and deployed correctly. 若尚未完成此動作,請參閱:If you haven't see:

  2. 設定儲存空間:備份資料可以儲存在磁碟、磁帶及 Azure 雲端。Set up storage - You can store backed up data on disk, on tape, and in the cloud with Azure. 深入了解 Prepare data storage (準備資料儲存空間)。Read more in Prepare data storage.

  3. 設定 DPM 保護代理程式:每部要備份的電腦都必須安裝 DPM 保護代理程式。Set up the DPM protection agent - You'll need to install the DPM protection agent on every machine you want to back up. 請參閱部署 DPM 保護代理程式Read Deploy the DPM protection agent.

設定備份Configure backup

  1. 若要建立保護群組,請按一下 [保護] > [動作] > [建立保護群組],開啟 DPM 主控台的 [建立新保護群組精靈]。To create a protection group, click Protection > Actions > Create Protection Group to open the Create New Protection Group wizard in the DPM console.

  2. 在 [選取保護群組類型] 中,選取 [伺服器]。In Select Protection Group Type, select Servers.

  3. 在 [選擇群組成員]**** 中選取您要保護之伺服器的 SQL Server 執行個體。In Select Group Members, select the SQL Server instances on the server you want to protect. 深入了解 Deploy protection groups (部署保護群組)。Learn more in Deploy protection groups. 請注意:Note that:

    • 您可以選擇進行執行個體層級的保護或個別資料庫的保護。You have the option of selecting protection at the instance level or protection of individual databases.

    • 當您以執行個體層級進行保護時,所有加入該 SQL Server 的資料庫都會自動加入 DPM 保護中。When you are protecting at the instance level, any database that is added to that instance of SQL Server will automatically be added to DPM protection.

    • 如果您使用 SQL Server AlwaysOn 可用性群組,則可以建立包含可用性群組的保護群組。If you are using SQL Server AlwaysOn availability groups, you can create a protection group that contains the availability groups. DPM 會偵測可用性群組,並將其顯示於 [叢集群組]**** 下。DPM detects the availability groups and will displays them under Cluster Group. 選取保護整個群組,所有加入該群組的資料庫都會自動受到保護;或選取個別資料庫。Select the whole group to protect it so that any databases that you add to the group are protected automatically, or select individual databases. 您也可以針對各個 SQL Server 執行個體執行系統狀態備份或完整裸機備份。For each instance of SQL Server, you can also run a system state backup or full bare metal backup. 如果您希望能夠復原整部伺服器而不是只有資料,這個方法就很實用。This in useful if you want to be able to recover your whole server and not just data.

  4. 在 [選擇資料保護方式] 中指定短期與長期備份的處理方式。In Select data protection method, specify how you want to handle short and long-term backup. 短期備份一律是先儲存在磁碟,配合使用 Azure 備份從磁碟備份至 Azure 雲端的選項 (短期或長期皆適用)。Short-term back up is always to disk first, with the option of backing up from the disk to the Azure cloud with Azure backup (for short or long-term). 長期雲端備份還有另一種選擇,亦即設定在連線到 DPM 伺服器獨立的磁帶裝置或磁帶媒體櫃長期備份。As an alternative to long-term backup to the cloud you can also configure long-term back up to a standalone tape device or tape library connected to the DPM server.

  5. 在 [選擇短期目標] 中指定在磁碟上儲存短期備份的方式。In Select short-term goals, specify how you want to back up to short-term storage on disk. 在 [保留範圍] 中指定磁碟保留資料的時間長度。In Retention range, you specify how long you want to keep the data on disk. 在 [同步處理頻率] 中指定磁碟執行增量備份的頻率。In Synchronization frequency, you specify how often you want to run an incremental backup to disk. 如不想設定備份間隔,您可選取 [恰好在復原點之前]****,讓 DPM 在接近每個排程的復原點前執行快速完整備份。If you don't want to set a back up interval, you can select Just before a recovery point so that DPM will run an express full backup just before each recovery point is scheduled.

    注意

    隨附記錄、處於唯讀模式或使用簡單復原模型的 SQL Server 資料庫不支援增量備份。SQL Server databases that are log-shipped, in read-only mode, or that use the simple recovery model do not support incremental backup. 系統只會針對每個快速完整備份建立復原點。Recovery points are created for each express full backup only. 對於所有其他 SQL Server 資料庫,同步處理會傳輸交易記錄備份,而且系統會針對每個增量同步處理和快速完整備份建立復原點。For all other SQL Server databases, synchronization transfers a transaction log backup, and recovery points are created for each incremental synchronization and express full backup. 交易記錄是自從最後一次備份交易記錄之後,根據資料庫所執行之所有交易的循序記錄。The transaction log is a serial record of all the transactions that have been performed against the database since the transaction log was last backed up.

  6. 如果想要將資料長期儲存在磁帶中,請在 [指定長期目標] 中指定磁帶資料的保留年限 (1-99 年)。If you want to store data on tape for long-term storage, in Specify long-term goals, indicate how long you want to keep tape data (1-99 years). 在 [備份頻率] 中指定磁帶備份應執行的頻率。In Frequency of backup specify how often backups to tape should run. 頻率是根據您指定的保留範圍而定︰The frequency is based on the retention range you've specified:

    • 當保留範圍是 1 到 99 年時,您可以選取以下備份頻率:每日、每週、每兩週、每月、每季、每半年或每年。When the retention range is 1-99 years, you can select backups to occur daily, weekly, bi-weekly, monthly, quarterly, half-yearly, or yearly.

    • 當保留範圍是 1 到 11 個月時,您可以選取以下備份頻率:每天、每週、每兩週或每月。When the retention range is 1-11 months, you can select backups to occur daily, weekly, bi-weekly, or monthly.

    • 當保留範圍是 1 到 4 週時,您可以選取以下備份頻率:每日或每週。When the retention range is 1-4 weeks, you can select backups to occur daily or weekly.

    在獨立磁帶機上,對於單一保護群組,DPM 會使用相同的磁帶來進行每日備份,直到該磁帶上的空間不足。On a stand-alone tape drive, for a single protection group, DPM uses the same tape for daily backups until there is insufficient space on the tape. 您也可以在磁帶上共置不同保護群組的資料。You can also colocate data from different protection groups on tape.

    在 [選取磁帶和媒體櫃詳細資料] 頁面中,指定要使用的磁帶/媒體櫃,以及是否應該壓縮與加密磁帶資料。On the Select Tape and Library Details, page specify the tape/library to use, and whether data should be compressed and encrypted on tape.

  7. 在 [檢閱磁碟配置] 頁面中,檢閱針對此保護群組配置的存放集區磁碟空間。In the Review disk allocation page review the storage pool disk space allocated for the protection group.

    [資料大小總計] 是您想要備份的資料大小,而要佈建在 DPM 上的 [磁碟空間] 是 DPM 建議的保護群組空間。Total Data size is the size of the data you want to back up, and Disk space to be provisioned on DPM is the space that DPM recommends for the protection group. DPM 會根據設定選擇理想的備份磁碟區。DPM chooses the ideal backup volume, based on the settings. 不過,您可以編輯 [磁碟配置詳細資料] 中的備份磁碟區選擇。However, you can edit the backup volume choices in the Disk allocation details. 對於工作負載,請在下拉式功能表中選取慣用的存放裝置。For the workloads, select the preferred storage in the dropdown menu. 您的編輯會變更 [可用的磁碟儲存體] 窗格中的 [儲存體總計] 和 [可用儲存體]。Your edits change the values for Total Storage and Free Storage in the Available Disk Storage pane. 未佈建的空間是 DPM 建議您將加入磁碟區的儲存體數量,之後才能順利繼續備份。Underprovisioned space is the amount of storage DPM suggests you add to the volume, to continue with backups smoothly in the future.

  8. 在 [選擇複本的建立方式] 中,選取您要如何處理首次的完整資料複寫。In Choose replica creation method, select how you want to handle the initial full data replication. 如果您選擇要透過網路複寫,我們建議您選擇離峰時間。If you select to replicate over the network we recommended you choose an off-peak time. 若是大量資料或網路狀況不佳,請考慮使用卸除式媒體離線複寫資料。For large amounts of data or less than optimal network conditions, consider replicating the data offline using removable media.

  9. 在 [選擇一致性檢查選項] 頁面中,選取您想要自動執行一致性檢查的方式。In Choose consistency check options, select how you want to automate consistency checks. 只有當複本資料變得不一致,或是排程指示時,您才能執行檢查。You can enable a check to run only when replica data becomes inconsistent, or according to a schedule. 如果您不想設定自動一致性檢查,您可以在 DPM 主控台的 [保護] 區域中,以滑鼠右鍵按一下保護群組,然後選取 [執行一致性檢查] ,以手動方式隨時執行檢查。If you don't want to configure automatic consistency checking, you can run a manual check at any time by right-clicking the protection group in the Protection area of the DPM console, and selecting Perform Consistency Check.

  10. 如果您已選擇使用 Azure 備份來備份到雲端,在 [指定線上保護資料] 頁面上,請確定已選取您想要備份至 Azure 的工作負載。If you've selected to back up to the cloud with Azure Backup, on the Specify online protection data page make sure the workloads you want to back up to Azure are selected.

  11. 在 [指定線上備份排程] 中,指定增量備份至 Azure 的頻率。In Specify online backup schedule, specify how often incremental backups to Azure should occur. 您可以將備份排程為每日、每週、每月、每年執行,並選取備份的執行時間和日期。You can schedule backups to run every day/week/month/year and the time/date at which they should run. 一天最多可以備份兩次。Backups can occur up to twice a day. 每次執行備份時,就會從儲存在 DPM 磁碟上的已備份資料複本,建立 Azure 資料復原點。Each time a back up runs a data recovery point is created in Azure from the copy of the backed up data stored on the DPM disk.

  12. 在 [指定線上保留原則] 中,您可以指定如何在 Azure 中保留根據每日/每週/每月/每年備份建立的復原點。In Specify online retention policy, you can specify how the recovery points created from the daily/weekly/monthly/yearly backups are retained in Azure.

  13. 在 [選擇線上複寫] 中,指定如何首次完整複寫資料。In Choose online replication, specify how the initial full replication of data will occur. 您可以透過網路進行複寫,也可以執行離線備份 (離線植入)。You can replicate over the network, or do an offline backup (offline seeding). 離線備份會使用 Azure 匯入功能。Offline backup uses the Azure Import feature. 如需詳細資訊,請參閱使用 Azure 資料箱離線植入For more information, see Offline seeding using Azure Data Box.

  14. 在 [摘要] 頁面上檢閱您的設定。On the Summary page, review your settings. 按一下 [建立群組] 後,就會執行資料的初始複寫。After you click Create Group initial replication of the data occurs. 完成時,保護群組在 [狀態] 頁面的狀態會顯示為 [確定]。When it finishes the protection group status will show as OK on the Status page. 接著會根據保護群組設定執行備份。Backup then takes place in line with the protection group settings.

監視Monitoring

建立保護群組之後,就會發生初始複寫,而且 DPM 會開始備份並同步處理 SQL Server 資料。After the protection group's been created the initial replication occurs and DPM starts backing up and synchronizing SQL Server data. DPM 會監視初始同步處理和後續備份。DPM monitors the initial synchronization and subsequent backups. 您可以透過幾種方法監視 SQL Server 資料:You can monitor the SQL Server data in a couple of ways:

  • 使用預設 DPM 監視可以設定主動監視的通知。Using default DPM monitoring can set up notifications for proactive monitoring. 透過發佈警示及設定通知。by publishing alerts and configuring notifications. 您可以透過電子郵件傳送重要、警告或資訊性警示,以及已具現化復原的狀態等通知。You can send notifications by e-mail for critical, warning, or informational alerts, and for the status of instantiated recoveries.

  • 如果使用 Operations Manager,您可以集中發佈警示。If you use Operations Manager you can centrally publish alerts.

設定監視通知Set up monitoring notifications

  1. 在 [DPM 系統管理員主控台] 中,依序按一下 [監視] > [動作] > [選項] 。In the DPM Administrator Console, click Monitoring > Action > Options.

  2. 按一下 [SMTP 伺服器] ,輸入伺服器名稱、連接埠與要做為通知傳送目的地的電子郵件地址。Click SMTP Server, type the server name, port, and email address from which notifications will be sent. 必須是有效地址。The address must be valid.

  3. 在 [已驗證的 SMTP 伺服器] 中,輸入使用者名稱和密碼。In Authenticated SMTP server , type a user name and password. 使用者名稱和密碼必須是擁有上述步驟中「寄件者」地址該人員的網域帳戶名稱,否則通知傳遞就會失敗。The user name and password must be the domain account name of the person whose "From" address is described in the previous step; otherwise, notification delivery fails.

  4. 若要測試 SMTP 伺服器設定,請按一下 [傳送測試電子郵件] ,輸入您想要 DPM 傳送測試訊息的電子郵件地址,然後按一下 [確定] 。To test the SMTP server settings, click Send Test E-mail, type the e-mail address where you want DPM to send the test message, and then click OK. 依序按一下 [選項] > [通知] ,然後選取要向收件者通知之警示的類型。Click Options > Notifications and select the types of alerts about which recipients want to be notified. 在 [收件者] **** 類型中,輸入您要 DPM 傳送通知副本的每位收件者電子郵件地址。In Recipients type the e-mail address for each recipient to whom you want DPM to send copies of the notifications.

使用 Operations Manager 設定警示Set up alerts with Operations Manager

  1. 在 [DPM 系統管理員主控台] 中,依序按一下 [監視] > [動作] > [選項] > [發佈警示] > [發佈作用中警示]。In the DPM Administrator Console, click Monitoring > Action > Options > Alert Publishing > Publish Active Alerts

  2. 啟用 [發佈警示] 後,系統會將所有可能需要使用者動作的現有 DPM 警示發佈到 [DPM 警示] 事件記錄檔。After you enable Alert Publishing all existing DPM alerts that might require a user action are published to the DPM Alerts event log. DPM 伺服器上已安裝的 Operations Manager 代理程式便會接著將這些警示發佈到 Operations Manager,並在產生新警示時繼續更新主控台。The Operations Manager agent that is installed on the DPM server then publishes these alerts to the Operations Manager and continues to update the console as new alerts are generated.

允許 SQL Server 系統管理員還原資料Allow SQL Server admins to restore data

DPM 提供自助式復原功能,以允許 SQL Server 系統管理員存取受 DPM 保護的資料,進而將 SQL Server 資料庫從備份還原到網路資料夾。DPM provides a self-service recovery feature to allow SQL Server administrators access to data protected by DPM, so that they can restore a SQL Server database from backup to a network folder. 您可以使用 [DPM 自助式復原組態工具],來建立與管理指定哪些使用者可以執行自助式復原的角色。You set up the DPM Self-Service Recovery Configuration Tool to create and manage roles that specify which users can perform self-service recovery. 然後使用者會使用 [DPM 自助式復原精靈] 來復原 SQL Server 資料庫。Then users use the DPM Self-Service Recovery Wizard to recover SQL Server databases.

如下設定自助式 SQL Server 復原:Configure self-service SQL Server recovery as follows:

  1. 在 DPM 主控台 > [保護],按一下 「Configure self service recovery」 (設定自助式復原)。In the DPM console > Protection click Configure self service recovery.

  2. 在 SQL Server 的 [DPM 自助式復原組態工具] 中按一下 [建立角色]****。In the DPM Self-Service Recovery Configuration Tool for SQL Server click Create Role.

  3. 在 [安全性群組] 頁面上,您將會建立一或多個群組,其中包含要啟用自助式復原的使用者。On the Security Groups page, you'll create one or more groups that contain the users for whom you want to enable self-service recovery. 以網域\安全性群組格式指定安全性群組,或以網域\使用者名稱格式指定個別使用者。Specify security groups in the format domain\security group, or an individual user in the format domain\user name. 您可以將多個群組和使用者新增至 DPM 角色。You can add multiple groups and users to a DPM role.

  4. 在 [復原項目]**** 頁面上指定受保護的 SQL Server 執行個體和您要允許自助式復原的資料庫。On the Recovery Items page you specify protected SQL Server instances and databases for which you want to allow self-service recovery. 以 <電腦名稱\執行個體名稱> 格式指定執行個體。Specify instances in the format <computer name\instance name>. 若要指定資料庫,請按下 TAB 鍵,然後輸入資料庫名稱。To specify a database press the TAB key, and then type a database name. 或者,讓角色使用者復原執行個體上的所有資料庫,按 TAB 鍵,然後按空格鍵清除 [資料庫名稱]**** 資料行中的文字。Alternatively, to enable role users to recover all databases on the instance, press the TAB key, and then press the spacebar to clear the text in the Database Name column.

    請注意,當您讓 DPM 角色的使用者復原 SQL Server 執行個體上的所有 SQL Server 資料庫時,那些使用者也將可復原任何後續新增至執行個體的 SQL Server 資料庫。Note that when you enable users of a DPM role to recover all SQL Server databases on an instance of SQL Server, those users can also recover any SQL Server databases that are subsequently added to the instance. 當您啟用使用 DPM 角色的存取時,請確定該角色的所有成員都已被授與檢視和存取所有資料庫的適當權限。When you enable access by using DPM roles, ensure that all members of the role have been granted appropriate permission to view and access all databases.

  5. 在 [復原目標位置]**** 頁面上,按一下 [允許使用者將資料庫復原至另一個 SQL Server 執行個體]**** 限制角色使用者的復原位置,並指定一或多個允許的復原目標位置和檔案路徑。On the Recovery Target Locations page, to restrict recovery locations for role users click Allow users to recover the databases to another instance of SQL Server and specify one or more recovery target locations and file paths that are allowed. 如要允許執行個體的任何路徑,請不要在 「Recovered File Path」 (復原的檔案路徑) 中指定值。If you want to allow any path on an instance then don't specify a value in Recovered File Path. 如果啟用設定,則使用者可將資料庫檔案復原至其有寫入權的任何位置。If you enable the setting users can recover database files to any location for which they have write permission. 不過,使用者無法覆寫原始的資料庫檔案,而且當他們嘗試這麼做時,SQL Server 的 DPM 自助式復原組態工具 (SSRT) 會加以封鎖。However, users cannot overwrite the original database files, and the DPM Self-Service Recovery Tool (SSRT) for SQL Server blocks them if they attempt to do so.

  6. 此外,在要執行自助式復原的電腦上,確定至少已安裝 .NET framework 3.5,並且安裝了 DPM 自助式復原工具。In addition on the computer from which self-service recovery will run make sure that at least .NET framework 3.5 is installed, and that the DPM Self-Service Recovery Tool is installed. 此工具位在 DPM 產品安裝位置的 [DpmSqlEURInstaller]**** 資料夾中。The tool is available in the DPM product installation location, in the DpmSqlEURInstaller folder.

還原 SQL Server 資料Restore SQL Server data

您可以使用下列方法復原 SQL 資料:You can recover SQL data as follows:

  • 將資料庫復原到原始位置Recover a database to the original location

  • 以新名稱將資料庫復原到原始位置,或復原到其他的 SQL Server 執行個體Recover the database with a new name to its original location or to a different instance of SQL Server

  • 將資料庫復原到其他的 SQL Server 執行個體Recover the database to a different instance of SQL Server

  • 將資料庫複製到網路資料夾Copy the database to a network folder

  • 將資料庫複製到磁帶Copy the database to tape

請注意,您無法將系統資料庫復原到其他的 SQL Server 執行個體。Note that you can't recover a system database to a different instance of SQL Server.

從 DPM 主控台復原資料庫,如下所示︰Recover a database from the DPM console as follows:

  1. 在 [DPM 系統管理員主控台] 中,按一下巡覽列上的 [復原]****。In the DPM Administrator Console click Recovery on the navigation bar. 使用瀏覽功能,選取要復原的資料庫。Using the browse functionality, select the database you want to recover.

  2. 在行事曆上,按一下任何一個粗體日期即可知道該日期可用的復原點。On the calendar, click any date in bold to obtain the recovery points available for that date. [復原時間] 功能表會列出每個可用復原點的時間。The Recovery time menu lists the time for each available recovery point. 在 [復原時間]**** 功能表上,選取要使用的復原點。On the Recovery time menu, select the recovery point you want to use.

  3. 按一下 [動作]**** 窗格中的 [復原]****,啟動 [復原精靈]。In the Actions pane, click Recover to start the Recovery Wizard.

  4. 在 [檢閱復原選項]**** 頁面上,按 [下一步]****。On the Review recovery selection page, click Next. 請注意:Note that:

    • 選取您要復原資料庫的位置。Select where you want to recover the database. 如果選取 [復原到任何 SQL 執行個體]****,請輸入復原路徑。If you select Recover to any SQL instance enter the recovery path. 您可以為復原的資料庫指定新名稱。You can specify a new name for the recovered database. 請注意,[最新的復原點]**** 設定不提供這個選項。Note that this option isn't available with the setting Latest recovery point.

    • 預設復原路徑為原始位置路徑。The default recovery path is original location path. 您必須輸入適當的復原路徑。You must enter appropriate recovery path.

    • 您無法將較新版本的 SQL Server 資料庫復原到較舊版本的 SQL Server 執行個體。You can't recover a newer version SQL Server database to an older version SQL Server instance.

    • 如果您選取 [複製到網路資料夾],且您選取的復原點不是透過快速完整備份所建立,您將會看到新的復原點選擇。If you select Copy to a network folder and the recovery point that you selected wasn't created from an express full backup, you'll be presented with new recovery point choices.

    • 如果您選取 [複製到磁帶] ,且您選取的復原點不是透過快速完整備份所建立,您將會看到新的復原點選擇。If you select Copy to tape and the recovery point that you selected wasn't created from an express full backup, you'll be presented with new recovery point choices. 對於磁帶選項,您將選取要用來復原的磁帶媒體櫃。For the tape option you'll select the tape library you want to use for recovery.

  5. 如果選取 [最近] 以外的復原點,在 [指定資料庫狀態] 頁面上選取 [讓資料庫處於可供使用的狀態]。If you selected a recovery point other than Latest, on the Specify Database State page, select Leave database operational.

  6. 指定網路頻寬使用節流設定、SAN 型復原、電子郵件通知的復原選項,然後按 [下一步]****。Specify recovery options for network bandwidth usage throttling, SAN-based recovery, and e-mail notifications, and then click Next.

  7. 在 [摘要資訊]**** 頁面上,檢閱復原設定,然後按一下 [復原]****。On the Summary page, review the recovery settings, and then click Recover.

有自助式復原權限的使用者應如下所示進行復原︰Users with self-service recovery permissions should recover as follows:

  1. 使用者應該開啟 DPM 自助式復原工具,按一下 [連線到 DPM 伺服器]****,然後指定 DPM 伺服器的名稱。The user should open the DPM Self-Service Recovery Tool, click Connect to DPM server, and specify the DPM server name.

  2. 建立連線後,使用者應該按一下 [新增復原工作]**** 啟動 [復原精靈]。After a connection is established the user should click New Recovery Job to start the Recovery Wizard.

  3. 在精靈的 [指定資料庫詳細資料]**** 頁面中,指定要復原的 SQL Server 執行個體和資料庫名稱。On the Specify Database Details page of the wizard, specify the SQL Server instance and database name to recovery. 若使用可用性群組,請以下列格式指定群組名稱:AGNAME.ClusternameFQDN\AGNAMEIf you're using availability groups specify the group name in the format: AGNAME.ClusternameFQDN\AGNAME.

  4. 在 [指定復原點]**** 頁面中選取復原點的日期與時間。On the Specify Recovery Point page select the data and time of recovery point.

  5. 在 [選擇復原類型]**** 頁面中,選取要復原到相同 SQL Server 的任何執行個體還是其他執行個體。On the Select Recovery Type page select whether to recovery to any instance on the same SQL Server or a different one. 指定是否要復原到網路資料夾。Specify whether to recover to a network folder. 請注意,只有會從快速完整備份建立的復原點,才能復原到網路資料夾。Note that only recovery points that will created from full express backup can be recovered to a network folder.

  6. 若要復原到資料庫,請在 [指定資料庫狀態]**** 頁面中,指定資料庫在復原後是否應該保持運作,並指定是否要複製 SQL 交易記錄。If you're recovering to a database, on the Specify Database State page specify whether the database should remain operational after recovery, and specify whether you want to copy SQL transaction logs.

  7. 在 [指定復原選項]**** 頁面中,指定要保留來源伺服器的安全性設定,還是要套用目的地伺服器的設定。On the Specify Recovery Options page specify whether you want to retain security settings from the source server, or apply settings from the destination server. 您也可以指定復原完成時,應傳送電子郵件通知。You can also specify that an email notification should be sent when recovery finishes.