Limited Functionality Error After Cumulative update

After Installing cumulaive update on all Lync servers we need to update database.
Installation of update will be very smooth and very less issues.But when it comes to update database its very critical and your heart beat will increase!!!For me yes..i have very bad experience on update database command.Whenever i have updated my database(SQL Cluster) My lync shows limited Functionlity error.
I tried with bothe of the commands

1- Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <EEBE.Fqdn> -UseDefaultSqlPaths

2- Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <EEBE.Fqdn>

Initially i struggled alot and played in SQL,but no luck last i got the solution.
Whenever i am getting Limited Functionlaty error i went and checked in my SQL databases using SQL management Studio and Found my rtcdyn database changed to single user mode.If i try to alter the same to multiuser mode it will not allow.
But Dont worry rtcdyn doesn't have any critical datat and it is only a dynamic content based on users login and activities it will udate.So what i done here is

Stoped SQL services
Gone to the physical path of the rtcdyn data path and Log Path
Renamed those files to something Else
Started SQL services
Open SQL Management Studio
Now you can see empty rtcdyn Database
Just right Click and delete the same.
Now goto the Front end server and run Below command

Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn < EEBE.Fqdn > -DatabasePaths <RtcDyn log path>, <RtcDyn data path>

 This will recreate your rtcdyn database and if you signout your Lync and signin back you can see preence and contacts.
Enjoy!!!!!!

If you have any suggession or any other solution Feel free to write here in Comments.

 

Move CMS from Lync 2010 to Lync 2013

When we introduce Lync 2013 on Lync 2010 infra CMS will be on Lync 2010.So if we want to move the CMS to new 2013 pool here is the steps.
For safer part we can take config backup using export-csconfig and export-cslisconfig.
Next step is to install CMS store new Lync 2013 pool for that run the below command.

Install-Csdatabase -centralmanagementdatabase -usedefaultsqlpaths -sqlserverfqdn <backendsqlserverfqdn>

Next step is to move CMS server.

move-csmanagementserver

If the source cms server is offline you can use below command.

Move-CsManagementServer -ConfigurationFileName "C:\configfile.zip" -LisConfigurationFileName "C:\CsLisConfigfile.zip" -Force

SQL Server Cannot open user default database Login Failed

As a Lync support person you might need to handle some SQL issues. Most of the cases you want to move database here and there because of the disk space issue or for proper allocation of disk. Here i faced a challenge while doing LCSLOG database movement from one disk to another Disk.

I have detached the database and copy the database in another disk after that i was not able to login to SQL management studio. I was getting "Cannot open user default database.Login Failed error".

I thought my SQL got corrupted ,After lot of search i got the solution like below.

Open SQL Managemnet Studio
Select options tab

Now change the connect to database to master or any available database on your setup

 

Now click on connect and it will successfully log you in. Once you login in the system run following statement for your username and it should fix your problem. Make sure to replace [test] with your username and master with yourdatabase name.

ALTER LOGIN [username] WITH DEFAULT_DATABASE = master
GO

 

 

Change Lync Database default path

This is one of the major topic which i faced lot of issues.I tried multiple time to create databse using install-csdatabase command but it always create database its on logic.not wher you want.So after lot of study i found a solution and moved databse in to proper disks where i required.
Here in my case most of the databses created in C drive.I wanted create in E drive.Find the below steps how i achived the same.
Logon to SQL server
Open SQL managemnet Studio
Click on New Query
Follow the Steps Below
Example:-
rtccab
Note down the database path
  use rtcab
  go
  sp_helpfile
  go
C:\CsData\ABSStore\(default)\dbpath\rtcab.mdf
c:\csdata\absstore\(default)\logpath\rtcab.ldf
Detatch the databse
   use master
   go
   sp_detach_db 'rtcab'
   go

Lync 2010 Limited Functionality error

This issue i have faced 3 or 4 times.But i haven't seen solution anywher in the net.First it took more time to identify the issu.So i thought this may help people like me.

First you verify the databse status from Backend sql managemnet studio.
Status of rtc and rtcdyn databse.This problem because of inconsistencies in rtcdyn databse.
If the problem started after Lync CU4 update then run the second command mentioned in lync kb article to restore the rtcdyn databse.Mostly this will resolve the issue.

Still You are facing the issue and you are not seing any ubnormalities in the databses please verify the permission of rtcdyn database.RTCUniversalservice shoud have read write permission on rtcdyn database

Last option is to stop all front end services.Login to Backend server,drop the rtcdyn database and create the database using install-csdatabase -update command from the lync fronend server.

Hope this will help you.Any updates please comment.............