Post reply

This differential backup cannot be restored because the database has not been restored to the correct earlier state.

  • August 20, 2012 at 3:45 pm

    #1527879

    Grant Fritchey (8/20/2012)

    Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.

    Thanks. I guess I have to recrate the maintenance plan because when I edit the plan I do not see an option to change it.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • August 21, 2012 at 9:42 am

    #1528204

    Welsh Corgi (8/20/2012)

    Grant Fritchey (8/20/2012)

    Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.

    Thanks. I guess I have to recrate the maintenance plan because when I edit the plan I do not see an option to change it.

    Yes you can. Check the option to "back up databases across one or more files" and then change the "Append" to "Overwrite."

    Of course, I suggest calling a stored proc rather than creating a maintenance plan. There are several scripts out there that you can use, and you have much more control.

    Jared
    CE - Microsoft

  • August 21, 2012 at 12:58 pm

    #1528335

    SQLKnowItAll (8/21/2012)

    Welsh Corgi (8/20/2012)

    Grant Fritchey (8/20/2012)

    Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.

    Thanks. I guess I have to recrate the maintenance plan because when I edit the plan I do not see an option to change it.

    Yes you can. Check the option to "back up databases across one or more files" and then change the "Append" to "Overwrite."

    Of course, I suggest calling a stored proc rather than creating a maintenance plan. There are several scripts out there that you can use, and you have much more control.

    Thanks. 🙂

    Could you please send me a link or to two to your favorite scripts?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • August 21, 2012 at 1:04 pm

    #1528341

    Welsh Corgi (8/21/2012)

    SQLKnowItAll (8/21/2012)

    Welsh Corgi (8/20/2012)

    Grant Fritchey (8/20/2012)

    Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.

    Thanks. I guess I have to recrate the maintenance plan because when I edit the plan I do not see an option to change it.

    Yes you can. Check the option to "back up databases across one or more files" and then change the "Append" to "Overwrite."

    Of course, I suggest calling a stored proc rather than creating a maintenance plan. There are several scripts out there that you can use, and you have much more control.

    Thanks. 🙂

    Could you please send me a link or to two to your favorite scripts?

    Arguably one of the best scripts that exist: http://ola.hallengren.com/

    Jared
    CE - Microsoft

  • January 19, 2015 at 3:24 am

    #1771066

    @SSChampion

    Thanks so much! ur answer helped me save sooo much time trying to debug a simple issue!!

  • March 25, 2016 at 12:34 am

    #1867689

    This may happen as the full backup may have more than 1 file and you restore is it without passing file=2 or whatever is last logical file in the output of below command

    restore headeronly from disk='c:\backup.bak'

    please pass correct value to file parameter while restoring and issue must be resolved

    Thanks

    Mohammed Haroon

  • March 25, 2016 at 5:07 am

    #1867708

    This post is old. 🙂

    I got replies that addressed this issue.

    Thanks.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply