• Thanks David. I am able to resolve that issue.

    But here the problem is if we have a backup of distributor around 4 A.M in the morning and the server crashed at 3 A.M next morning we will be loosing lot of transactions.Would you suggest to take backups more often ? If we take the case of high OLTP environment this will create more issues. Again with table sizes of 30 GB, it's very difficult to run the commands and sync manually.

    I am working to setup synchronous mirroring for the distribution server. For this i have to change the recovery model for the distribution database. Any suggestions ?