Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

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 meta data from the restored database.


sp_restoredbreplication [ @srv_orig = ] 'original_server_name'
[ @db_orig = ] 'original_database_name'
[ , [ @keep_replication = ] keep_replication ]


[@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

For internal use only.


sp_restoredbreplication is used in all types of replication.


Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_restoredbreplication.

© 2015 Microsoft