This article applies to PST Enterprise version 3.1 or higher.
You can change the SQL instance used by PST Enterprise. For example, if you have reached the maximum database size limit for SQL Express instances and wish to migrate to a full SQL server instance.
To change the SQL Server instance,
- Confirm your PST Enterprise system configuration.
- Confirm you have a copy of the PST Enterprise installer which is needed to reinstall PST Enterprise. If you do not have a copy, contact Barracuda Networks Support.
- On the PST Enterprise server, stop the PSTEnterprise and PSTEnterpriseSelfService websites in Internet Information Services (IIS) Manager to prevent clients from connecting during the SQL database migration.
- (Optional but recommended). Migrate the PST Enterprise database (PSTEnterprise) to the new SQL instance. For migration options, refer to the Microsoft blog Nice things inside SQL Server, System Center Configuration Manager.
- The database name must be PSTEnterprise.
- If you do not migrate the database, all your previous configuration (discovered PSTs, client configuration, policies, etc.) are lost. You must reapply this configuration once PST Enterprise is configured to use the new SQL instance.
- Verify the PST Enterprise Admin account has the required SQL database permissions.
- Once the SQL database is migrated, uninstall PST Enterprise from the Control Panel.
- Reinstall PST Enterprise.
- It is not necessary to re-run the Pre-Installation Package as the same version of PST Enterprise is being reinstalled.
- Select the new SQL instance but keep all other settings based on the current PST Enterprise configuration.
- Once reinstalled, start the PSTEnterprise and PSTEnterpriseSelfService websites in IIS Manager. Clients can now reconnect and continue processing.
PST Enterprise is now configured to use the new SQL instance.