In a distributed database, if you modify some of the structures in the primary database, then the SnapShot database is maintained and the primary database is consistent, you should do the following: 1. Delete the snapshot log on the database, so that the table to synchronize can not synchronize 2. Modify the table structure on the primary database 3. Re-create Snapshot on the primary database 4. Delete Snapshot on the Snapshot database 5. Recreate Snapshot on the snapshot database 6. Check the synchronization situation - Query the view on the snapshot machine Select * from sys.dba_jobs t --failures !!!
