Move Lync FE local database to another location

Sometimes, you may want to move Lync FE local database to another location.

Detail action steps as below:
======================
Note: We are not moving the xds database which is a replica or CMS which is not that I/O intensive.

1. Stop all the Lync related services on the Lync FE server.

2. Launch SQL management studio and connect to the RTCLOCAL instance of this Lync FE server.

3. Check the current location of rtc and rtcdyn database, right click each database properties-->Files

(The default location of database file is “c:\CsData\RtcDatabaseStore\rtclocal”)

4. Detach the rtc and rtcdyn database

5. Move the two database & log folders to new path.

6. In SQL management studio right click “Database” and then click “Attach”

7. Attach the database rtc: select the database file from new database path, and select the log file from the new log path:

8. Attach the rtcdyn databases according same process.

9. Run below SQL commands  from SQL query window:

• Click on New query and type the following command

alter database rtc set db_chaining on

• Click Execute and you should see an output that the command completed successfully

• In the query window change the database to rtcdyn:

alter database rtcdyn set db_chaining on

• Click Execute and you should see an output that the command completed successfully

10. Then, start the Lync services on this Lync FE server.