Moving a directory database (PSTFlightdeckDirectory) (4339209)

Issue
Sometimes it might be necessary to move a directory database (PSTFlightdeckDirectory), E.G. to a faster SQL server or to a new SQL server instance.
Solution
It is possible to achieve this goal by performing the following steps:

1. Stop PST Flight Deck services and application pools
2. Move a directory database (PSTFlightdeckDirectory)
3. Make sure the PST Flight Deck service account has access to a new SQL Server / SQL instance via Microsoft SQL Server Management Studio
4. Config files update
5. Start PST Flight Deck application pools and services again

 Stop PST Flight Deck services and application pools

1. Run System Services (services.msc)
2. Stop PST Flight Deck Core Service and all post process module services (right-click on the service and select Stop)
3. Run Internet Information Services Manager (iis.msc)
4. Stop PST Flight Deck application pools (right-Click on the application pool and select Stop):
   1. PSTFlightDeckAppPool (if Operator Web interface is installed)
   2. PSTFlightDeckWSAppPool

 Move a directory database (PSTFlighdeckDirectory)

1. Take a backup of PSTFlightdeckDirectory database
2. Copy the database file into a new location
3. Restore the database on a new location

Make sure the PST Flight Deck service account has access to new SQL Server / SQL instance via Microsoft SQL Server Management Studio

Make sure you can access the database on a new location and you can open any table.

Config files update

Update these config files:

1. Web Service config file It is necessary to update the database connection string in “Web.config” file located in PST Flight Deck installation directory (default path is: “C:\Program Files\QUADROtech\PST FlightDeck\Core WebService\Web.config”):
   SQLSERVER\INSTANCE;Initial Catalog=PSTFlightdeckDirectory;Integrated Security=SSPI;Application Name=QUADROtech PST Flightdeck;” providerName=”System.Data.SqlClient”/>
   
   
2. Core Service config fileYou need to update the database connection string in “vcare.PstMigrator.Service.exe.config” file located in PST Flight Deck installation directory (default path is: “C:\Program Files\QUADROtech\PST FlightDeck\Core Service\vcare.PstMigrator.Service.exe.config”):
   SQLSERVER\INSTANCE;Initial Catalog=PSTFlightdeckDirectory;Integrated Security=SSPI;Application Name=QUADROtech PST Flightdeck;” providerName=”System.Data.SqlClient”/>
   
   
3. FlightDeck Admin Console config fileYou need to update the database connection string in “FlightDeck.exe.config” file located in PST FlightDeck installation directory (default path is: “C:\Program Files\QUADROtech\PST FlightDeck\UI\FlightDeck.exe.config”):
   SQLSERVER\INSTANCE;Initial Catalog=PSTFlightdeckDirectory;Integrated Security=SSPI;Application Name=FlightDeckSME;”/>
   
4. Operator Web Interface config fileYou need to update the database connection string in “Web.config” file located in PST FlightDeck installation directory (default path is: “C:\Program Files\QUADROtech\PST FlightDeck\WebUI\Web.config”):
   SQLSERVER\INSTANCE;Initial Catalog=PSTUI;Integrated Security=SSPI;Application Name=QUADROtech PST Flightdeck;”/>
   SQLSERVER\INSTANCE;Initial Catalog=PSTFlightdeckDirectory;Integrated Security=SSPI;Application Name=QUADROtech PST Flightdeck;”/>
   NOTE: If you want to move also the database used for the Operator Web Interface (PSTUI) it is necessary to update the particular connections string in this config file (PSTUI).

Start PST Flight Deck application pools and services again

1. Run Internet Information Services Manager (iis.msc)
2. Start PST Flight Deck application pools (right-Click on the application pool and select Start):
   1. PSTFlightDeckWSAppPool
   2. PSTFlightDeckAppPool (if Operator Web interface is installed)
3. Run System Services (services.msc)
4. Start PST Flight Deck Core Service (right-click on the service and select Start) and check the particular log files:
   1. Web Service log file (in C:\Program Files (x86)\QUADROtech\Logs\hosted-PSTFlightDeck.log)
   2. Core Service log file (in C:\Program Files (x86)\QUADROtech\Logs\FlightDeck Core.log)
5. If there are no SQL related errors in the log file proceed with the next step.
6. Start the Password Remover service and monitor the Password Remover log file (in C:\Program Files (x86)\QUADROtech\Logs\FlightDeck Module (Password Remover).log) to ensure proper functionality. Below is an example of log output showing normal functionality with no work to be done:
   [2014.12.02 08:56:09:868]             [ 9932]  [    1]      [TRACE] [Main] No User interface detected – starting as service
   [2014.12.02 08:56:09:948]             [ 9932]  [    1]      [DEBUG] [Main]               Service created.
   [2014.12.02 08:56:09:948]             [ 9932]  [    6]      [INFO] [OnStart]              Service started.
   [2014.12.02 08:56:09:962]             [ 9932]  [    8]      [TRACE] [Start]  Initializing task processor
   [2014.12.02 08:56:09:962]             [ 9932]  [    8]      [DEBUG] [Initialize]         Retrieving Module ID from web service
   [2014.12.02 08:56:10:133]             [ 9932]  [    8]      [DEBUG] [Initialize]         Registered module under ID: 5
   [2014.12.02 08:56:10:133]             [ 9932]  [    8]      [TRACE] [Start]  Starting task loop
   [2014.12.02 08:56:10:188]             [ 9932]  [    8]      [DEBUG] [Process]          Result from service is null or empty WorkItem set.
7. Start the other FD post process modules services as well and check the appropriate log files.
8. Open the PST Flight Deck Admin Console and make sure it runs properly.
9. If Web Operator Interface is installed: Try to open it in the browser and make sure it can be loaded properly.
10. If no issue is discovered so far do a full end to end test with a PST file.