Want to share the issue that We faced during Lync 2010 CU update.
Below error was logged :-
Not a major upgrade; using existing file and log file paths for dynamic database
Using existing dyndb path of X:\mssql\prod\data
Using existing dynlog path of Y:\mssql\prod\data
Opened database rtcdyn
Restricting access and dropping database.
Dropped database rtcdyn
Creating database rtcdyn
DbFile : PhysicalName = X:\mssql\prod\data\rtcdyn.mdf
LogFile: PhysicalName = Y:\mssql\prod\data\rtcdyn.ldf
Failed to create database rtcdyn
Researched internet & gone thru various articles but none of them applied to us.
On further working with MS Support we found the issue with the SQL cluster configuration.(we also tested that we were not able to create any new databases on the SQL server)
Issue was clustered disks were not part of SQL, so we added those disks in dependencies & ran the below command:
Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn < Fqdn > -DatabasePaths <RtcDyn log path>, <RtcDyn data path>