SharePoint 4 Developers

Additional reference guide in .NET / SharePoint Development

Rename the Search service application databases in SharePoint 2013

If you are looking at this article: http://technet.microsoft.com/en-us/library/jj219654.aspx to rename the search service application databases, be aware that the approach does not work for some databases. Here it is the workaround.

Hi folks,

If you are looking at this article: http://technet.microsoft.com/en-us/library/jj219654.aspxto rename the search service application databases, be aware that the following approach does not work:

 
To rename the databases by using SQL Server Management Studio
  1. In Management Studio, connect to the source SQL Server instance, and then expand Databases.

  2. Right-click the Search service application database that you want to rename, click Rename, and then type the new name. Repeat this step for each database that you want to rename.

Note: This is not correct for all databases!

This approach only works for the AnalyticsReporting database!

Here it is the trickiest part that is not explained in the article:

If you want to rename the Crawl and Links databases, backup each of these databases and restore them with the new names.

Then you can proceed with the article. Be aware that there are typos with the code snippets provided, as I mention here.

I hope it helps,

Cheers,

Marcel Medina

Click here to read the same content in Portuguese.

blog comments powered by Disqus