Topic Last Modified: 2011-04-06

After you remove a Microsoft Lync Server 2010 Monitoring Server or reconfigure the server to use a different database, you can remove the SQL Server databases that hosted the server data. Use the following procedures to remove the definitions from Topology Builder, and then remove the database and log files from the database server.

To remove the SQL Server database using Topology Builder

  1. Log on to the computer where Lync Server Management Shell is installed as a member of the RTCUniversalServerAdmins group or with the necessary user rights as described in Delegate Setup Permissions.

  2. Start Topology Builder: Click Start, click All Programs, click Microsoft Lync Server 2010, and then click Lync Server Topology Builder.

  3. When Topology Builder prompts you to select the source of the Lync Server 2010 topology documents, click Download Topology from existing deployment, and then click OK.

  4. In Save Topology As, type a name for the topology document in File name, and then click Save.

  5. Expand SQL Stores, right-click the SQL Server instance associated with the removed or reconfigured Monitoring Server, and then click Delete.

    Warning:
    If you accidentally delete the wrong object and you have not published the topology yet, right-click the Lync Server 2010 node, click Download Topology, and then click Yes in Confirm Download Topology.
  6. Publish the topology, and then check replication status.

To remove the database files from the SQL Server

  1. To remove the databases on the SQL Server-based server, you must be a member of the SQL Server sysadmins group for the SQL Server server where you are removing the database files.

  2. Log on to the computer where Lync Server Management Shell is installed as a member of the RTCUniversalServerAdmins group or with the necessary user rights as described in Delegate Setup Permissions.

  3. Start the Lync Server Management Shell: Click Start, click All Programs, click Microsoft Lync Server 2010, and then click Lync Server Management Shell.

  4. Type:

    Copy Code
    Uninstall-CsDataBase -DatabaseType Monitoring -SqlServerFqdn <FQDN> [-SqlInstanceName <instance>]
    

    Where <FQDN> is the fully qualified domain name (FQDN) of the database server, and <instance> is the optional named database instance.

  5. When the Uninstall-CsDataBase cmdlet prompts you to confirm actions, read the information, and then press Y (or press Enter) to proceed, or press N and then Enter if you want to stop the cmdlet (that is, in case there errors).