Refreshing a Primary Database of a Replication setup into DEV/QA.

When we load a replicated database into another server, it will not come up/online due to secondary truncation point was set in the source database.

  

After Load is completed, when you issue online database command, It will be failed due to the replication setup i.e. secondary truncation point of repagent. Error Message: Database 'DBName' cannot be brought online because it has replicated tables that may not be completely transferred. After making sure that your replication is in sync, use dbcc dbrepair to remove the secondary truncpt.

dbcc dbrepair(DBName,ltmignore) go online database DBName go