After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Are you looking for a
Jersey Girl T-Shirt
?
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent Friday fish fry!
|
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
|
|
|
|
