Return
-
Title
Messages “Source table is not in database“ when running “repair using” on a config file with wildcards and sequences conforming to wildcards. -
Description
When “repair using” is issued on a file with wildcards where the source database has sequences conforming to those wildcard entries, the following messages are observed in sp_ctrl session that issued the command:
sp_ctrl>repair using <file_name>
Cannot repair "OWNER"."SEQUENCE_NAME"
Source table is not in database
Here are the contents of the file file_name:
datasource:o.source_SID
expand OWNER.% OWNER.% targetserver@o.target_SID
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.