A quick note about moving databases in SharePoint

If you need to move databases from one server to another and not just from one disk to another on the same server there are some pretty good documentation to be found.

The thing they neglect to mention – or at least the documentation I used (Microsoft official btw) – is that you need to move the search database as well. They just focus on content and configuration databases.

For this one customer I work for this "oversight" resulted in event id 5586 and 6398 with source "Windows SharePoint Services 3" in the application log.

To move your search database start by going to Central administration -> Operations -> Servers in Farm and stop the Search service. You will get a warning about horrible disaster and the end of the world but just click OK.

Now you start the service again and in the next screen enter the information for the new server. If you, like me, have already moved the search database to the new database server you need to either throw it away or use another name in the SharePoint admin interface.

Et voila, your search database is now moved to the new database server.

Don't forget to assign your sites an indexer (as you removed the old one above).

Leave a Reply