• Perry,

    Sorry.

    We take Full backups every night so, applying a diff backup is out of question for us. Also, i have restored the secondary using a new backup of the primary. The log shipping is in sync now.

    I wasn't sure if the DB state change will break the log shipping and have put out the question for any answers.

    Thanks