A Transact-SQL command that turns off replication for an offline database that has a valid secondary truncation point.
dbcc dbrepair(database_name, ltmignore)
The name of the database for which you want to turn off replication.
Use dbcc dbrepair for RepAgent- and LTM-enabled databases.
Like the dbcc settrunc('ltm', 'ignore') Adaptive Server command, the dbcc dbrepair command with the ltmignore option turns off replication for a database that has a valid secondary truncation point.
Use dbcc dbrepair when the Adaptive Server cannot bring the database online because the secondary truncation point is valid, and where the transaction log contains log records that need to be drained.
If you are using a replicated database, use dbcc dbrepair to load a SQL Server release 10.0.x dump into a SQL Server release 11.0.x database or any Adaptive Server database. Examples include:
Loading a dump from a SQL Server release 10.0.x production system into an Adaptive Server release 12.0 test system, or
In a warm standby application, initializing a SQL Server release 11.0.x standby database with a database dump from a SQL Server release 10.0.x active database.
