First run this query

select log_reuse_wait_desc from sys.databases where name= 'dbname'.

If it returns log backup take 2 continuous log backups to truncate the log .

Hi Joe,

I don't know how to set , Can you please explain how to set this switch clearly.

I searched so many articles every where they specified it as parameter.

Please...

Hi Roy,

The publlisher,subscriber and distributor are on the same server.

Network latency is also good.

can i improve the over all performance by configuring distirbutor on serprate server and by changing agent...

Hi Suresh ,

The table has around 3 crores of records,but and the files loading will happen continuously

hence we can't apply snapsh every time.

Thanks

venkat