Logo 
Search:

Sharepoint Articles

Submit Article
Home » Articles » Sharepoint » GeneralRSS Feeds

Log usage data in a different logging database by using Windows PowerShell

Posted By: Destin Joy     Category: Sharepoint     Views: 66777

In this article we can see how we can Log usage data in a different logging database by using Windows PowerShell

 

You use Windows PowerShell to change this setting.

To log usage data in a different logging database by using Windows PowerShell

1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin (http://technet.microsoft.com/en-us/library/ff607596.aspx).

2. On the Start menu, click All Programs.

3. Click Microsoft SharePoint 15 Products.

4. Click SharePoint 15 Management Shell.

5. At the Windows PowerShell command prompt (that is, PS C:\>), type the following command, and then press ENTER:

Set-SPUsageApplication -DatabaseServer <Database server name> -DatabaseName <Database name> [-DatabaseUsername <User name>] [-DatabasePassword <Password>] [-Verbose]

You must specify the value for the DatabaseServer parameter, even if the new database is on the same database server as the old one. You must use both the DatabaseUsername and the DatabasePassword parameters if the database owner is a different user account from the one with which you logged on. To view the progress of the command, use the verbose parameter.

Share: 



Destin Joy
Destin Joy author of Log usage data in a different logging database by using Windows PowerShell is from Pathanamthitta, India. Destin Joy says

 Hello Everyone,

I am Destin Joy from India I have MCPD in SharePoint 2010, MCTS SharePoint 2010 application development and MCTS in SharePoint 2007. I am mostly working in  core part of SharePoint (2010-2007) and passionate about new Microsoft technologies. Born and brought up in Kerala You can reach me  @ Destin.Joy@hotmail.com

 

 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!