| title | sp_restoredbreplication (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | a2c5ee32-e6d9-46e9-8031-8ff13c20acf7 | ||
| caps.latest.revision | 28 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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 cannot be preserved. On the restore, the server calls sp_restoredbreplication directly to automatically remove replication metadata from the restored database.
Transact-SQL Syntax Conventions
sp_restoredbreplication [ @srv_orig = ] 'original_server_name'
, [ @db_orig = ] 'original_database_name'
[ , [ @keep_replication = ] keep_replication ]
[ , [ @perform_upgrade = ] perform_upgrade ]
[ @srv_orig = ] 'original_server_name'
The name of the server where the back up was created. original_server_name is sysname, with no default.
[ @db_orig = ] 'original_database_name'
The name of the database that was backed up. original_database_name is sysname, with no default.
[ @keep_replication = ] keep_replication
[!INCLUDEssInternalOnly]
[ @perform_upgrade= ] perform_upgrade
[!INCLUDEssInternalOnly]
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.