| title | sp_restoredbreplication (Transact-SQL) | ||
|---|---|---|---|
| description | sp_restoredbreplication removes replication settings when restoring a database to a non-originating server. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | replication | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server SQL MI]
Removes replication settings if restoring a database to the non-originating server, database, or system that is otherwise not capable of running replication processes. When restoring a replicated database to a server or database other than the one where the backup was taken, replication settings can't be preserved. On the restore, the server calls sp_restoredbreplication directly to automatically remove replication metadata from the restored database.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_restoredbreplication
[ @srv_orig = ] N'srv_orig'
, [ @db_orig = ] N'db_orig'
[ , [ @keep_replication = ] keep_replication ]
[ , [ @perform_upgrade = ] perform_upgrade ]
[ , [ @recoveryforklsn = ] recoveryforklsn ]
[ ; ]
The name of the server where the backup was created. @srv_orig is sysname, with no default.
The name of the database that was backed up. @db_orig is sysname, with no default.
[!INCLUDE ssInternalOnly]
[!INCLUDE ssInternalOnly]
[!INCLUDE ssInternalOnly]
0 (success) or 1 (failure).
sp_restoredbreplication is used in all types of replication.
Only members of the sysadmin or dbcreator fixed server role, or the dbo database schema, can execute sp_restoredbreplication.