So Microsoft brings out the Cumulative updates periodically for Lync 2010, at the time of writing this seems to be quarterly. As part of the update there is a requirement to update the Lync backend SQL databases with the update which in it own right is a simple update, yet time and time again i hear how people have royally screwed up there Lync environment by not understanding the SQL update instructions OR when they dont have the right permissions to the SQL database when running the update. <sysadmins is required to the databases>
(Below are the Note instructions for SQL as part of the Lync CU updates and where to run the Update from)
<<
Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <EEBE.Fqdn> -UseDefaultSqlPaths
Notes
- In a Lync Server 2010 Standard Edition environment, run the cmdlet from the Standard Edition server.
- In a Lync Server 2010 Enterprise Edition environment in which the archiving/monitoring services are collocated with an Enterprise Edition back-end server, run this cmdlet from the Enterprise Edition back-end server.
- In a Lync Server 2010 Enterprise Edition environment in which the archiving/monitoring services are not collocated with an Enterprise Edition back-end server , run this cmdlet from the Enterprise Edition front-end server.
If the RTCDyn databases are removed after you run the cmdlet without the UseDefaultSqlPaths parameter, run the following cmdlet to restore the RTCDyn databases:
Note The RtcDyn log is located under the path of the rtcdyn.ldf file. The RtcDyn data is located under the path of the rtcdyn.mdf file.
>>
I have experienced first hand when a client runs the update in error (User account does not have sysadmin rights to the Lync databases) and drops the SQL databases, with no way of restoring them. If you are reading this blog as your in the same predicament then do the following to get your Lync environment back online.
ERROR FROM SQL IN THE LOGS
Failed to create database rtcdyn
Error (
name: Error
description:
number: -2147221242
message:
)
—————
Exit code: ERROR_CREATE_DB (-4)
or this one in the deployment log
Error: Script failed (code “ERROR_CREATE_DB”) when installing “BackendStore” on “lync2010SQL01.northernlync.local”. For details, see the following log file: “C:\Users\lyncadmin\AppData\Local\Temp\Create-BackendStore-lyncdbserver.domain.com-[2012_12_24][22_48_19].log”
The users inability to create the necessary databases during this process causes the Lync system to go offline. But dont fear its easily resolved by adding the install account as sysadmin and re-running the Install-CSDatabase command.
Simple!
Rgds
Iain Smith