| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_restoredbreplication (Transact-SQL) |
sp_restoredbreplication removes replication settings when restoring a database to a non-originating server. |
markingmyname |
maghan |
randolphwest |
08/22/2024 |
sql |
replication |
reference |
|
|
|
[!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.