SharePoint 2010: How to log usage data in a different Database

PowerShell CmdLets Tips:

We cannot change the Usage Data Collection Database throug the CA interface, Logging database can be changed only through the PowerShell

We need to use Set-SPUsageApplication to change the Logging Database ,And Here is CmdLet

SPUsageApplication –Identity "Usage Collection" –DatabaseServer "SQLServerName" -DatabaseName "Your New Loggin Database Name"

Comments