As part of extending my pervious post (Renaming SharePoint 2010 Search Service Database Name) I’m planning to provide a walkthrough practice for changing the Database names for FAST Search for SharePoint 2010 (FS4SP). I will start this post by listing the FS4SP Databases, then walking through the practice of renaming these databases.

 

FAST Search for SharePoint 2010 Databases:

FS4SP mainly deals with 2 Search Service Application (SSA) - FAST Search Content SSA & FAST Search Query SSA – which consist of 3 databases each as following:

  • FAST Search Content SSA Databases:
    • Content SSA Administration Database
    • Content SSA Crawl Store Database
    • Content SSA Property Store Database

 

  • FAST Search Query SSA Databases:
    • Query SSA Administration Database
    • Query SSA Crawl Store Database
    • Query SSA Property Store Database

 

image

 

Renaming FAST Search for SharePoint 2010 Databases:

 

Renaming Content SSA Databases

Modifying the Crawl Store Databases for the FAST Content SSA can be edited using the Farm Search Administration page in the Central Administration as following:

  1. Go to Central Administration Home >> General Application Settings >> Farm Search Administration
  2. Click Modify Topology for the FAST Content SSA.
  3. In the Databases Section click the Crawl Database >> Edit Properties
  4. Rename the Database Name as needed (Ex: Remove the GUID from the Database Name) and click OK.
  5. The changes on the Topology will be in Pending Changes State. Click Apply Topology Changes to confirm these changes.

 

Note: The FAST Content SSA Property Store Database is not shown in the Central Administration.

 

Modifying the Administration and Property Store Databases for the FAST Content SSA can be edited using PowerShell as following:

  1. Login as Farm Administrator on the SharePoint 2010 Application Server 2010.
  2. Start >> All Programs >> Microsoft SharePoint 2010 Products >> SharePoint 2010 Management Shell >> Run as Administrator.
  3. To Rename the FAST Content SSA Administration Database use the following script:

      4. $ContentSSA = Get-SPEnterpriseSearchServiceApplication –identity "[FAST Content SSA Name]"

      $ContentSSA.Pause()

      $ContentSSA | Set-SPEnterpriseSearchServiceApplication -DatabaseName "[New FAST Content SSA DB Name]" –DatabaseServer "[DB Server Name]"

      $ContentSSA.Resume()

  4. To Rename the FAST Content SSA Property Store Database use the following script to get the Property Store Database GUID:

      5. Get-spdatabase

  5. Then run this script to rename the Property Store:

      6. $ContentSSA = Get-SPEnterpriseSearchServiceApplication –identity "[FAST Content SSA Name]"

      $ContentSSA.Pause()

      Set-SPEnterpriseSearchPropertyDatabase –Identity "[Property Store Database GUID]" -SearchApplication $ContentSSA -DatabaseName "[New FAST Content Property Store DB Name]" -DatabaseServer "[DB Server Name]"

      $ContentSSA.Resume()

     

 

Renaming Query SSA Databases

Modifying the Crawl and Property Store Databases for the FAST Query SSA can be edited using the Farm Search Administration page in the Central Administration as following:

  1. Go to Central Administration Home >> General Application Settings >> Farm Search Administration
  2. Click Modify Topology for the FAST Query SSA.
  3. In the Databases Section click the Crawl Database >> Edit Properties
  4. Rename the Database Name as needed (Ex: Remove the GUID from the Database Name) and click OK.
  5. In the Databases Section click the Property Database >> Edit Properties
  6. Rename the Database Name as needed (Ex: Remove the GUID from the Database Name) and click OK.
  7. The changes on the Topology will be in Pending Changes State. Click Apply Topology Changes to confirm these changes.

 

Modifying the Administration Databases for the FAST Query SSA can be edited using PowerShell as following:

  1. Login as Farm Administrator on the SharePoint 2010 Application Server 2010.
  2. Start >> All Programs >> Microsoft SharePoint 2010 Products >> SharePoint 2010 Management Shell >> Run as Administrator.
  3. To Rename the FAST Query SSA Administration Database use the following script:

      4. $QuerySSA = Get-SPEnterpriseSearchServiceApplication –identity "[FAST Query SSA Name]"

      $QuerySSA .Pause()

      $QuerySSA | Set-SPEnterpriseSearchServiceApplication -DatabaseName "[New FAST Query SSA DB Name]" –DatabaseServer "[DB Server Name]"

      $QuerySSA .Resume()

       

       

Hope you find it useful.