Renaming SharePoint 2013 Search databases

  • Article
 If you have had trouble moving your SharePoint 2013 Search Databases using the TechNet article below. 

  

 Move the Search service application databases in SharePoint 2013

This article may help.

First: The original databases need to be online with their original names for these PowerShell scripts to work. The only way to get this to work is to backup each database and restore them as new databases with the new names. Then you can run the PowerShell scripts to allow the Search service to use the new databases.

Second: Step 6 has some typos in it.

$LinksDatabase0 = ([array]($searchApp | Get-SPEnterpriseSearchLinksDatabase))[0]

$LinksDatabase0 | Set-SPEnterpriseSearchLinkDatabase [-DatabaseName "<NewDbName>"] -DatabaseServer "<NewServerName>"

  • Set-SPEnterpriseSearchLinkDatabase is not a valid commandlet. 

    Set-SPEnterpriseSearchLinksDatabase is the correct commandlet. Links is plural.

  • $searchApp variable has not been declared. $ssa is the variable that needs to be used for consistency .

Making these changes should make the database move work.

Comments

  • Anonymous
    January 01, 2003
    Looking at the referenced link above. It appears that TechNet has corrected the errors in the article. Please post if you find any problems with the current page.

  • Anonymous
    June 08, 2013
    Thank you....

  • Anonymous
    January 24, 2014
    Rob! Talked with Anthony about the article You saved me from the 3 hour nightmare of thinking I had missed a step last night. Worked like a charm with your input!