• Hi Phil,

    I agree with you but due to time constraint I could not investigate this issue in production. Prior to performing the process, I did performed the backups of msdb on both pubs and subs, distributer, publisher and subscriber databases. Once the issue fixed in production, I did restored these backups in our Test enviornments to investigate what caused the issue. Unfortunately we could not rectify the cause of this issue.

    Regards,

    Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

    http://basitaalishan.com