• Hemant.R (12/12/2012)


    hi mahesh,

    This error occurs when someone has run a process that has broken the log chain. Probably ran the command BACKUP LOG [Jul_Reports] WITH TRUNCATE_ONLY, or the database was switched to SIMPLE recovery and then back to FULL.

    if someone using backup log with truncate_only command in their job

    please set below trace flag

    3031

    3231

    it wont break lsn chain of database.

    you will get explaination for traceflag on google.

    A month old post :hehe:

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)