Hello Eason, thanks for your comment! So, if I understand your comments correctly, I DO need to use the "UseDefaultSQLPaths" paramater and that will NOT use the default instance or a default path like "program files\sql...", but the path I set for the data and log files during installation? Just to make sure Iam not messing up my sql machine ;-)

The command would be:

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

and it will upgrade/ install the databases that were stored in d:\apps\sqlserver\... to d:\apps\sqlserver\ as configured and NOT in c:\programfiles\sql...

Hi,

Run Install-CsDatabase with UseDefaultSqlPaths. This option does not use the built-in algorithm to optimize the log and data file locations. Log and data file are deployed according to the defaults set by the SQL Server administrator. These paths are typically set for the purpose of automatic administration of log and data files on the SQL Server in advance, and are not associated with the setup of Lync Server 2010.

When use the UseDefaultSqlPaths parameter, instructs SQL Server to select the drive where data and log files will be stored.

Best Regards,
Eason Huang

Hello,

Iam planning for a Lync Server 2010 update using the Lync update installer. I do not quite get how to update the database correctly.

Refer to article URL: https://support.microsoft.com/en-us/kb/2493736?wa=wsignin1.0

We do not use default paths of SQL server, so my thought is that I should not use:

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

But what should we use instead?? My thought would be:

Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <EEBE.Fqdn> -SQLInstanceName <server\instance> -databasepath <PATH log>, <PATH data>

But the article also states that :

"If you run the cmdlet without the UseDefaultSqlPaths parameter, the RTCDyn databases may be removed. Therefore, run the following cmdlet to restore the RTCDyn databases:

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

But that is practically the same command as the first one. So why is that necessary and how does it distinquish which database it should update. Am I interpreting this right?

Hi, with default path is the Default path of you instance mentioned.

If you have choosen a diferent path, you can select this by databasepath.

Hello Holger! Thanks for your reply. With " default path is the Default path of you instance mentioned." you mean that this is the standard paths that SQL uses during setup, right?

On Standard Edition Server and Enterprise Edition: Front end servers, once you have installed update for core components, the updated sql files will be dropped on the server. Then run the following cmdlet to apply the changes: 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:

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