Share via

  • Article

Remove the SQL Server Database for an Archiving Server

 

Topic Last Modified: 2011-04-06

After you remove a Microsoft Lync Server 2010 Archiving Server or reconfigure the server to use a different database, you can remove the SQL Server databases that hosted the pool 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 Archiving 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.

    Note

    For details, see Common Procedures for Removing Servers Running Lync Server and Lync Server Components.

To remove the database files from the SQL Server

  1. To remove the databases on the SQL Server, you must be a member of the SQL Server sysadmins group for the SQL 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:

    Uninstall-CsDataBase -DatabaseType Archiving -SqlServerFqdn <FQDN> [-SqlInstanceName <instance>]

    Where <FQDN> is the fully qualified domain name (FQDN) of the database server, and <instance> is the named database instance (that is, if one was defined).

  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).