Restoring a Stand-alone Monitoring or Archiving Database
Topic Last Modified: 2011-06-01
If the server that failed hosts one or more databases but does not run Lync Server services, you perform only the steps to install the SQL Server instance and run Topology Builder or the Install-CsDatabase cmdlet to recreate the databases and set access control lists (ACLs). This situation applies to servers running one or more databases for Archiving and Monitoring. For stand-alone databases, Topology Builder prompts you to create the database. You can use Topology Builder or the Install-CsDatabase cmdlet to recreate the database.
Archiving and monitoring data is not required for Lync Server to run normally.
The following procedure describes how to recreate the database so that you can continue to collect archiving or monitoring data. For details about restoring the data, see Restoring Monitoring or Archiving Data.
We recommend that you take an image copy of the system before you start restoration so that you can use this image as a rollback point in case something goes wrong during restoration. You might want to take the image copy after you install the operating system and SQL Server, and restore or re-enroll the certificates.
To recreate a stand-alone database
Start with a clean or new server that has the same fully qualified domain name (FQDN) as the failed server, install the operating system, and then restore or re-enroll the certificates.
Follow your organization's server deployment procedures to perform this step.
From a user account that is a member of the RTCUniversalServerAdmins group, log on to the server you are restoring.
Install SQL Server 2008 R2, SQL Server 2008, or SQL Server 2005, keeping the instance name the same as before the failure.
Depending on your deployment, the server might include multiple databases. Follow the same procedure to install SQL Server that you used originally to deploy the server, including SQL Server permissions and logins.
Recreate the database by publishing the topology, as follows:
Start Topology Builder: Click Start, click All Programs, click Microsoft Lync Server 2010, and then click Lync Server Topology Builder.
Click Download Topology from existing deployment, and then click OK.
Select the topology, and then click Save. Click Yes to confirm your selection.
Right-click the Lync Server 2010 node, and then click Publish Topology.
Follow the Publish the Topology wizard. On the Create databases page, select the databases you want to recreate.
Follow the rest of the wizard, and then click Finish.
Instead of running Topology Builder, you can use the Install-CsDatabase cmdlet to create each database. For details, see the Lync Server Management Shell documentation.
Restore the data. For details, see Restoring Monitoring or Archiving Data.