sys.sp_change_feed_reseed_db_init (Transact-SQL)

2025-08-21

Applies to: SQL Server 2025 (17.x) Preview Azure SQL Database Azure SQL Managed Instance Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Preview

Executes a database reseed.

Caution

This system stored procedure is used internally and isn't recommended for direct administrative use. Use the Fabric portal instead. Using this procedure could introduce inconsistency.

This system stored procedure is used for Microsoft Fabric mirrored databases and SQL database in Microsoft Fabric.

Syntax

Transact-SQL syntax conventions

sys.sp_change_feed_reseed_db_init
    @is_init_needed tinyint

Arguments

is_init_needed

Internal use only.

Returns

0 (success) or non-zero (failure).

Remarks

A reseed stops the current mirrored database and reinitializes the mirroring. This involves generating a new initial snapshot of the tables configured for mirroring and then incremental changes are replicated. During reseed, the old mirrored database item in Microsoft Fabric is still available but does not receive incremental changes.

Permissions

A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.

Examples

A. Initiate manual reseed event

As a best practice, test manual reseed for a specific database to understand the impact before turning on the automatic reseed functionality.

USE <Mirrored database name>
GO
EXECUTE sp_change_feed_reseed_db_init @is_init_needed = 1;