When upgrading a primary database, the Rep Agent, Log Transfer
Agent or Mirror Activator must not be running, and you should turn off
the secondary truncation point for the duration of the upgrade.
The Rep Agent or Log Transfer Manager should be shut down prior to the upgrade.
For each primary database and replicated RSSD, disable the
secondary truncation point:
-
Disable
the secondary truncation point in the Adaptive Server database that
is being upgraded by issuing:
1> use database
2> go
1> dbcc settrunc('ltm', 'ignore')
2> go
-
If the dbcc settrunc command fails, make
sure that the Rep Agent or LTM are not running. When the Rep Agent
and LTM are disabled, repeat the first step.
-
Truncate the primary transaction log running the
command:
1> dump tran primary_dbname with truncate_only
2> go
-
Stop Replication Server then zero out the Replication
truncation point. In the RSSD for the Replication Server, run:
1> rs_zeroltm primary_servername, primary_dbname
2> go