PerformancePoint Service database created by default contains GUID as suffix in name. But what if we dont want GUID in name and want to provide name with proper naming convention. I faced this issue in my project , then I came to know how it can be done. I will take you through a number of steps following which we can rename database .
1.) Start SharePoint 2010 Central Administration -> System Settings -> Manage Services on Server.
2.) Locate PerformancePoint Service and click Stop.
3.) Start SQL Server Management Studio , backup PerformancePoint Service database .
4.) In left pane of Management Studio , right click Databases and select 'Restore Database'.
5.) Provide new database name for 'To Database' textbox, select 'From Device' option and browse to the backup of old PerformancePoint database. Select Ok.
6.) Now Go to Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management PowerShell.
7.) Type below command to get all information about PerformancePoint Service Application:
Get-SPPerformancePointServiceApplication "PerformancePoint Service Application"
8.) Declare a new variable and assign new database name to that variable :
$newdatabasename = "<New Database Name>" (Name without angle brackets)
9.) Assign new database to PerformancePoint Service :
Set-SPPerformancePointServiceApplication -Identity "PerformancePoint Service Application" -SettingsDatabase $newdatabasename
10.)We are done with SharePoint 2010 Management Powershell.
11.) Navigate to 'Manage Services on Server ' and start the PerformancePoint service , if not started.
12.) Last step is to delete Old PerformancePoint Service database from SQL Server.
1.) Start SharePoint 2010 Central Administration -> System Settings -> Manage Services on Server.
2.) Locate PerformancePoint Service and click Stop.
3.) Start SQL Server Management Studio , backup PerformancePoint Service database .
4.) In left pane of Management Studio , right click Databases and select 'Restore Database'.
5.) Provide new database name for 'To Database' textbox, select 'From Device' option and browse to the backup of old PerformancePoint database. Select Ok.
6.) Now Go to Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management PowerShell.
7.) Type below command to get all information about PerformancePoint Service Application:
Get-SPPerformancePointServiceApplication "PerformancePoint Service Application"
8.) Declare a new variable and assign new database name to that variable :
$newdatabasename = "<New Database Name>" (Name without angle brackets)
9.) Assign new database to PerformancePoint Service :
Set-SPPerformancePointServiceApplication -Identity "PerformancePoint Service Application" -SettingsDatabase $newdatabasename
10.)We are done with SharePoint 2010 Management Powershell.
11.) Navigate to 'Manage Services on Server ' and start the PerformancePoint service , if not started.
12.) Last step is to delete Old PerformancePoint Service database from SQL Server.
Thank you for the post i found it very helpful
ReplyDeletebut you do have a 'typo' int the 'Get' & 'Set' Cmdlets
Get-SPerformancePointServiceApplication
Set-SPerformancePointServiceApplication
Sould be
Get-SPPerformancePointServiceApplication
Set-SPPerformancePointServiceApplication
Once again many thanks
Thanks for bringing this to my notice. I have updated it now.
Delete