Return
-
Title
The compare with force option results in error “Cannot compare owner.table_name, required information is missing” “Missing target host name” and “Missing target SID” -
Description
The following errors are observed “compare force” is issued on a table that exists in the source and target database and is not a part of replication:
sp_ctrl (source_server:5438)> compare sha90.table1e force
Cannot compare "SHA90"."TABLE1E", required information is missing
Missing target host name
Missing target SID
comparing 0 of 1 objects
1 object(s) contain errors
No objects to compare; no job started.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.