MY Current database in SIMPLE recoverey model
I have set up the transactional replication. MY log reader process wakes up and runs every 5 min. Does my transactions will get deleted or they still in log file as active even it is in simple recover model.
Logreader how it reads the Transaction log files . I observed today we are running some big reports. those reports uses INSERT INTO FROM <TABLE > this process showing in DBCC OPENTRAN
MY log reader keep on reading the log file.. it did not come out from that five min duration...
Can someone from the MS share the what /how exactly log reader works ( inside details)
I would like to add more details
The Log Reader Agent is scanning the transaction log for commands to be replicated. Approximately 30500000 log records have been scanned in pass # 3, 1696 of which were marked for replication, elapsed time -623164036 (ms).
The Log Reader Agent is scanning the transaction log for commands to be replicated. Approximately 31000000 log records have been scanned in pass # 3, 1713 of which were marked for replication, elapsed time -177869239 (ms).
everytiome counter startwith 500000 records and keegoing for some time and it is delivering the transactions never stopping the job
Why elpse time is in negative
How to understan
Do you guys think it is really sc
Thanks
Srini