Hi Shibu Thomas,
In my research, you can try to move Lync database to new SQL Server as the following steps:
1.
Export Lync configuration just in case.
Export-CsConfiguration -file c:\lyncconfig.zip
Export-CsLisConfiguration -file c:\lynclisconfig.zip
2.
Install a new Lync server in a new pool: temppool.corp.local.
3.
Install a new CMS on temporary SQL server.
Install- CsDatabase -CentralManagementDatabase -sqlserverfqdn tempsql.corp.local
4.
Enable topology.
Enable-CsTopology
5.
Logon to new server in new pool and move CMS Lync server.
Move-CsManagementServer
Verify that you are moving it to the new server and select.
Get-CsManagementStoreReplicationStatus
Wait for replication.
6.
Uninstall old CMS database.
Uninstall-CsDatabase -CentralManagementDatabase -sqlserverfqdn OLDSQLSERVERFQDN.corp.local
7.
Backup Lync databases. All of them.
8.
In topology builder create a new SQL server at the enterprise pool properties and publish topology.
9.
Run Lync server setup deployment wizard.
10.
Turn off all Lync frontend servers.
11.
Restore Databases to the newly created databases. Remember to enable Chaining on the RTC and RTCDYN databases. Enable cross database chaining in the SQL server properties.
12.
Start Lync servers.
13.
Move CMS to new SQLserver. step 1 – 6
14.
Delete temppool from topology builder and publish.
Reference links:
Export-CsConfiguration:
https://docs.microsoft.com/en-us/powershell/module/skype/export-csconfiguration?view=skype-ps
Export-CsLisConfiguration:
https://docs.microsoft.com/en-us/powershell/module/skype/export-cslisconfiguration?view=skype-ps
Install-CsDatabase:
https://docs.microsoft.com/en-us/powershell/module/skype/install-csdatabase?view=skype-ps
Enable-CsTopology:
https://docs.microsoft.com/en-us/powershell/module/skype/enable-cstopology?view=skype-ps
Move-CsManagementServer:
https://docs.microsoft.com/en-us/powershell/module/skype/move-csmanagementserver?view=skype-ps
Get-CsManagementStoreReplicationStatus:
https://docs.microsoft.com/en-us/powershell/module/skype/get-csmanagementstorereplicationstatus?view=skype-ps
Uninstall-CsDatabase:
https://docs.microsoft.com/en-us/powershell/module/skype/uninstall-csdatabase?view=skype-ps
Best Regards,
Sharon Zhao
Please remember to
mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact
tnsf@microsoft.com.