SharePoint 2013 如何恢复服务器场的内容数据（Content Database）Azure 环境

本文内容：

2种恢复方式介绍 和SharePoint 2013 数据库对照表。

第一种方式：使用 Central Administration 方式。

To recover content from an unattached content database by using Central Administration

1.  Click Start, click Microsoft SharePoint 2013 Products, and then click SharePoint 2013 Central Administration.
     
2.  In Central Administration, on the home page, click Backup and Restore.


3.  On the Backup and Restore page, in the "Granular Backup" section, click "Recover data from an unattached content database."


4.  On the Unattached Content Database Data Recovery page, type the database server name in the Database Server text box and type the database name in the Database Name text box.


5.  Select the database authentication method that you want to use.

6.  Select the Browse content option, and then click Next.

7.  On the Browse content page, select the site collection, site, and or list that you want to restore, select the Backup site collection or Export site or list option, and then click Next.

8.  Type the file location where you want to store the backup file, and then click Start Backup. For more information about using the Backup site collection option, see Back up site collections in SharePoint 2013.

If you chose Export site or list in the previous page, you must select Export Full Security and choose the version that you want to export in the Export Versions drop-down menu. For more information about using the Export site or list option, see Export sites, lists, or document libraries in SharePoint 2013.

第二种方式：

 At the Windows PowerShell command prompt, type the following command:

  Get-SPContentDatabase -ConnectAsUnattachedDatabase  -DatabaseName <DatabaseName> -DatabaseServer <DatabaseServer>

     Where:
     <DatabaseName> is the name of the unattached database from which you want to recover content.
     <DatabaseServer> is the name of the database server that hosts the unattached database from which you want to recover content.

For more information, see Get-SPContentDatabase.

Note: We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions. 

SharePoint 2013 Production Farm Topology


The SharePoint 2013 production farm topology consists of the servers listed in the following table.


The Wide World Importers SharePoint 2013 environment has the following characteristics:


- A hardware load-balancer is configured to balance traffic between PROD-WEB-01 and PROD- WEB-02.
- SSRS is installed on PROD-APP-01 in SharePoint integrated mode.
- SSRS report databases are stored on PROD-DB-01.
- A site collection named Report Center has been created at http:// reports.wideworldimporters.com.
- All SharePoint content and configuration databases are stored on PROD-DB-01.
- All site collections have been migrated to a single content database named WSS_Content.
- A content database named WSS_TempContent has been restored to PROD-DB-01, but not attached to the SharePoint 2013 farm.
- An AD DS domain user account named PPS_SVC has been created.


SharePoint 2013 Disaster Recovery Site


The SharePoint 2013 Disaster Recovery farm topology consists of the servers listed in the following table.


Technical Requirements


- Log shipping must be used to send transaction log backups to the instance of SQL Server that is running in the disaster recovery site.
- Discrete sets of SharePoint content databases must be configured to automatically failover together.
- An additional SQL Server 2012 Report Server must be added to the SharePoint 2013 environment. The server must be configured to use SharePoint integrated mode.
- Additional SQL Server 2012 Report Servers must not be installed on machines that are running SharePoint as a front-end web server.
- Site Collection administrators must not have the ability to upgrade site collections.
- Site Collection upgrade jobs must be throttled to a maximum of five site collections at a time.
- A daily backup schedule must be created to perform SQL Server backups of all SharePoint content and configuration databases.
- The PPS_SVC AD DS user account must be used for the PerformancePoint service application.
- Farm administrators must be able to recover content from WSS_TempContent without attaching the database to the farm.
- All content databases within the production farm must be set to read-only when patching and upgrading the farm.
- Farm administrators must be able to determine which sites were missed or skipped during the upgrade process and must be able to monitor any future upgrades.