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.

Set-SPEnterpriseSearchLinkDatabase typo

Set-SPEnterpriseSearchLinkDatabase : The term 'Set-SPEnterpriseSearchLinkDatabase' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

Hi folks,

If you get the message below when you run the commandlet Set-SPEnterpriseSearchLinkDatabase don’t worry. It is a typo:

typo

The correct commandlet is:

Set-SPEnterpriseSearchLinksDatabase

Probably you should be getting that because you have tried to rename the Search Link database. Well, I got that from the TechNet article: http://technet.microsoft.com/en-us/library/jj219654.aspx, which contains an incorrect code snippet. The TechNet article was published on July 16, 2012 and was not updated.

Cheers,

Marcel Medina

Click here to read the same content in Portuguese.

Reimagine SharePoint Development

This is all about understanding more about apps, to learn about the proven practices of architecting and developing apps and migrating SharePoint solutions to apps.

Hi folks,

This webcast seems interesting. Check it if you want to understand more about apps, to learn about the proven practices of architecting and developing apps and migrating SharePoint solutions to apps. These are the words from the SharePoint Developer Team.

Here it is the link: Webcast

The SharePoint Development Team is taking pretty serious when they say: "As a SharePoint developer, you should make http://www.reimaginespdev.com your first stop when planning and developing your next app or migrating your existing SharePoint solution."

I want to check this session, so if you are a developer, I invite you to do the same.

Cheers,

Marcel

Click here to read the same content in Portuguese.