Change Usage and Logging Service Application Database Name

The database name of the WSS_Usage Service Application is created automatically. And you may want to change this name. For this;

  • First of all you should change database name on SQL Server Side. Above codes should be executed on SQL Server Management Studio Query Tool
USE master;
GO
ALTER DATABASE WSS_UsageApplication SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE WSS_UsageApplication Modify Name = 'TEST_UsageApplication'
GO
ALTER DATABASE TEST_UsageApplication SET MULTI_USER;
GO
  • Then change Service Application database name on Powershell side
Set-SPUsageApplication -Identity "WSS_UsageApplication" -DatabaseName "TEST_UsageApplication" -DatabaseServer "DATABASE_SERVERNAME"

Add a Comment

Your email address will not be published. Required fields are marked *