Change database (FAST Search Server 2010 for SharePoint)

 

Applies to: FAST Search Server 2010

In some cases, you may want to change the database that FAST Search Server 2010 for SharePoint uses, after the initial installation and configuration. An example may be if you have to reinstall the administration server.

Note

The post-setup configuration wizard creates a new database when you configure a single server or administration server. However, you can configure FAST Search Server 2010 for SharePoint to use another existing database after the configuration wizard has finished.

You can find the current settings for the database in <FASTSearchFolder>\etc\hostconfiguration.xml, where <FASTSearchFolder> is the path of the folder where you have installed FAST Search Server 2010 for SharePoint, for example C:\FASTSearch.

To change the database, follow these steps:

1. Make sure that the FAST Search user has access to the database server.

2. If you want to create a new empty database:

   1. On the Start menu, click All Programs.

   2. Click Microsoft FAST Search Server 2010 for SharePoint.

   3. Right click Microsoft FAST Search Server 2010 for SharePoint shell and select Run as administrator.

   4. At the Windows PowerShell command prompt, type the following command(s):

      Install-FASTSearchAdminDatabase -DbName <DatabaseName> -dbserver <ConnectionString>
      

      Where:

      • <DatabaseName> and <ConnectionString> are replaced with the appropriate values. See Configure the admin server in a multiple server deployment for more information.

3. On the FAST Search Server 2010 for SharePoint administration server, do the following:

   1. Stop FAST Search Server 2010 for SharePoint.

   2. Update the database server and database name in <FASTSearchFolder>\etc\hostconfiguration.xml.

      Note

      In case you use the FAST Search Lotus Notes connector or the FAST Search database connector, also update the database server and database name in <FASTSearchFolder>\etc\dbconfig.xml.

   3. On the Start menu, click All Programs.

   4. Click Microsoft FAST Search Server 2010 for SharePoint and then Microsoft FAST Search Server 2010 for SharePoint shell.

   5. At the Windows PowerShell command prompt, type the following command(s):

      Set-FASTSearchConfiguration
      

   6. Start FAST Search Server 2010 for SharePoint.