StoreFront

Manage the subscriptions database

March 13, 2025

Contributed by:

When you create a store, StoreFront creates a Microsoft Extensible Storage Engine (ESENT) database locally on the server to hold favorites (also known as subscription) data. In StoreFront server group environments, each server maintains its own copy of the database. Any changes to favorites are propagated to other servers to ensure users see the same favorites regardless of which server they connect to.

Alternatively, you can store favorites in a SQL Server database. For more information, see Store subscription data using Microsoft SQL Server.

To view whether a store is using a local ESENT database or a SQL server database, use the PowerShell script:

$store=Get-STFStoreService -VirtualPath '/Citrix/Store'
Get-STFStoreSubscriptionsDatabase -StoreService $store
<!--NeedCopy-->

Managing favorites data

When using an ESENT database, you can use PowerShell to manage the favorites data. For more information, see Manage favorites data. When use a SQL server database, you can use SQL to manage the records.

Syncing favorites between server groups

Subscriptions automatically synchronize between servers in a server group. If you have multiple server groups, then you can configure Citrix Files to periodically synchronize subscriptions between server groups. For more information, see Subscriptions synchronization.

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Manage the subscriptions database

March 13, 2025

Contributed by:

March 13, 2025

Contributed by:

Manage the subscriptions database

Managing favorites data

Syncing favorites between server groups

In this article