locked
restore diff and full file backup on sql server RRS feed

  • Question

  • dear all,


    Is possible restore one full backup file and one diff backup file with different month??i.e. full backup file on March and Diff file on April..??


    Thanks 4 all answer

    Best regards

    Thursday, May 10, 2012 2:40 AM

Answers

  • It is possible if you perform full backup on March and diff on April, nothing in the middle:-))))) I mean no full/diff backup between March and April.


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/


    • Edited by Uri DimantMVP Thursday, May 10, 2012 3:33 AM
    • Proposed as answer by Maggie Luo Friday, May 11, 2012 5:01 AM
    • Marked as answer by Maggie Luo Thursday, May 17, 2012 8:47 AM
    Thursday, May 10, 2012 3:32 AM
  • HI,

    When you take full backup SQL server there is something like mark identify the last full backup after that when you take differential backup SQL server backup your DB from last full backup till now.

    so make sure that there is no full backup (if there is one taken with copy only option there is no problem) taken between march (full backup) and April (Diff backup).

    I hope this is helpful.


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid

    MyBlog

    • Marked as answer by Maggie Luo Thursday, May 17, 2012 8:47 AM
    Thursday, May 10, 2012 5:33 AM

All replies

  • It is possible if you perform full backup on March and diff on April, nothing in the middle:-))))) I mean no full/diff backup between March and April.


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/


    • Edited by Uri DimantMVP Thursday, May 10, 2012 3:33 AM
    • Proposed as answer by Maggie Luo Friday, May 11, 2012 5:01 AM
    • Marked as answer by Maggie Luo Thursday, May 17, 2012 8:47 AM
    Thursday, May 10, 2012 3:32 AM
  • HI,

    When you take full backup SQL server there is something like mark identify the last full backup after that when you take differential backup SQL server backup your DB from last full backup till now.

    so make sure that there is no full backup (if there is one taken with copy only option there is no problem) taken between march (full backup) and April (Diff backup).

    I hope this is helpful.


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid

    MyBlog

    • Marked as answer by Maggie Luo Thursday, May 17, 2012 8:47 AM
    Thursday, May 10, 2012 5:33 AM
  • Hello Urang

    Please Verify From Microsoft Link

    http://msdn.microsoft.com/en-us/library/ms175510.aspx

    -- Assume the database is lost at this point. Now restore the full
    -- database. Specify the original full database backup and NORECOVERY.
    -- NORECOVERY allows subsequent restore operations to proceed.
    RESTORE DATABASE MyAdvWorks
       FROM MyAdvWorks_1
       WITH NORECOVERY;
    GO
    -- Now restore the differential database backup, the second backup on
    -- the MyAdvWorks_1 backup device.
    RESTORE DATABASE MyAdvWorks
       FROM MyAdvWorks_1
       WITH FILE = 2,
       NORECOVERY;
    GO
    -- Now restore each transaction log backup created after
    -- the differential database backup.
    RESTORE LOG MyAdvWorks
       FROM MyAdvWorks_log1
       WITH NORECOVERY;
    GO
    RESTORE LOG MyAdvWorks
       FROM MyAdvWorks_log2
       WITH RECOVERY;
    GO

    I hope Help you ..

    Best Regards


    Leonardo Martínez

    Thursday, May 10, 2012 2:25 PM