From this guys great Blog! http://blogs.technet.com/b/meamcs/archive/2012/10/23/renaming-sharepoint-2010-search-service-database-name.aspx
In this post I’m planning to walkthrough the practice of changing the SharePoint 2010 Search Service Database names as you might need it in the following scenarios:
- Replacing the Search Service Application Databases Names that Includes GUID’s to a friendlier name.
- The Database Admin in the Organization is planning to change the naming convention of all the Databases names in the Data Center.
- If you are planning to move from one Farm to another that has a different Naming Convention.
You have many options to do this practice as shown in the below figure, but in this post I will walkthrough the preferred steps only to make it simple and clear:
Renaming Property & Crawl DBs using Central Administration:
Verify that the user account that is performing the procedure is a member of the Farm Administrators SharePoint group.
- In Central Administration, click Application Management.
- On the Application Management page, click Manage service applications.
- Click the name of the Search Service Application.
- On the Search Administration page, click Modify.
- On the Manage Search Topology page, the following three databases are listed: Administration, Crawl, and Property. You can point to renamed or moved Crawl or Property databases by using this procedure.
- Click the database that you want to change, and then click Edit Properties.
- In the Database Server text box, type the new server location if there is one; in the Database Name text box, type the new name for the database; and then click OK.
- On the Manage Search Topology page, click Apply Topology Changes.
Notes:
- You cannot point to a renamed or moved Search Administration database by using Central Administration.
- It might take several minutes for the changes to take effect.
Renaming Search Service Application Database using PowerShell:
Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
- On the Start menu, click All Programs.
- Click Microsoft SharePoint 2010 Products.
- Click SharePoint 2010 Management Shell.
- At the Windows PowerShell command prompt, type the following commands:
-
- Point the Search Administration database to its new name or location.
$searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "<NewDbName>" -DatabaseServer "<NewServerName>"
Where:
-
-
-
- <NewDbName> is the name of the renamed database
-
- <NewServerName> is the new database location
- Monitor whether the search instances have finished re-provisioning.
Do {write-host -NoNewline .;Sleep 10; $searchInstance = Get-SPEnterpriseSearchServiceInstance -Local} while ($searchInstance.Status -ne "Online")
Additional References:
- Rename FAST Search for SharePoint 2010 Databases
- Rename or Move Service Application
- Change database (FAST Search Server 2010 for SharePoint)