sp_restoredbreplication (Transact-SQL)
Applies to: SQL Server Azure SQL Managed Instance
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
Syntax
sp_restoredbreplication [ @srv_orig = ] 'original_server_name'
, [ @db_orig = ] 'original_database_name'
[ , [ @keep_replication = ] keep_replication ]
[ , [ @perform_upgrade = ] perform_upgrade ]
Arguments
[ @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
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[ @perform_upgrade = ] perform_upgrade
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Return Code Values
0 (success) or 1 (failure)
Remarks
sp_restoredbreplication is used in all types of replication.
Permissions
Only members of the sysadmin or dbcreator fixed server role or the dbo database schema can execute sp_restoredbreplication.
See Also
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho