Of Interest
Business Intelligence and Analytics
Oracle Training
|
Sybase
»
Administration
»
Replication
»
Transaction Log
Removing the Replication Marker or Transaction Log Marker
When loading a database from a database which was replicated, it is necessary
to remove the replication transaction log marker - otherwise a good chunk
of the transaction log will go to waste (and may cause log-full situations
1> dbcc gettrunc
2> go
secondary trunc page secondary trunc state dbrepstat generation id database id database name ltl version
-------------------- --------------------- --------- ------------- ----------- ------------------------------ -----------
45626 1 167 0 16 database702 400
1> dbcc settrunc(ltm,ignore)
2> go
secondary trunc page secondary trunc state dbrepstat generation id database id database name ltl version
-------------------- --------------------- --------- ------------- ----------- ------------------------------ -----------
45626 0 166 0 16 database702 400
|
|
|
Get the latest Rocket99 news and tech tips via
|