Wss Usage and Health application Deleted accidentally RRS feed

  • Question

  • Hi team,

    I accidently deleted the Usage and Health service application and Now i am when i try to recreate it it still gives the error with old DB name . I am using Powershell to create the service application

    the error it gives is farm account is not able to open the old DB.

    Thanks Basva

    Thursday, August 20, 2015 8:41 PM


  • Hi,

    To recreate the Usage and Health service application, refer to the following steps:

    1. Deleted the Usage and Health service application from CA.
    2. Refer to the article: http://njbblog.blogspot.com/2014/01/sharepoint-2013-how-to-configure-usage.html create a new Usage and Health service application with PowerShell. we can't use an exists database, we need to use an not existed database named "WSS_UsageApplication1" 
    $SvcApp = New-SPUsageApplication –Name “WSS_UsageApplication” -DatabaseName "WSS_UsageApplication1" –DatabaseServer “SQL” 
    $SvcAppProxy = Get-SPServiceApplicationProxy | Where {$_.TypeName -like “Usage and Health*”}

    Now, we created the Usage and Health service application successfully.

    If you want to use the old database, refer to the following article about point the Usage and Health data collection service application to database by using Windows PowerShell:


    Best Regards,

    Lisa Chen

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, August 24, 2015 5:41 AM