none
Differental and log backup restore

    Question

  • i am trying to mirror the database,

    i have restored the full database backuop

    now i need to restore diff back and log backup.

    can i please has so assistance, i am not sure how to do it.


    k

    Sunday, July 14, 2013 9:52 PM

Answers

  • Hello!

    Restore the full backup using the option "WITH NORECOVERY", after that, restore the last differential backup and to finish, restore the log backups, for the last file you can use the option WITH RECOVERY to put the database Online.


    Regards,

    André César Rodrigues

    Please click the Mark as answer button and vote as helpful if this reply solves your problem. Thanks!

    Blog: http://sqlmagu.blogspot.com.br  LinkedIn:   

    • Marked as answer by '''HuuM''' Wednesday, July 17, 2013 1:47 PM
    Monday, July 15, 2013 2:27 AM

All replies

  • Use "WITH NORECOVERY" option in every restore (restore of full, restore of diff, restore of every tran. log). That will enable applying the next diff/tran log backup to the existing state of a database.
    Sunday, July 14, 2013 11:17 PM
  • i have got two diff backups since last full backup, so do i have to restore both of them and then log backups since last diff backup, is that the approach?

    k

    Monday, July 15, 2013 12:12 AM
  • Hi,

    You can restore the last diff backup and then log backups since last diff backup.


    Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

    Monday, July 15, 2013 2:03 AM
  • Hello!

    Restore the full backup using the option "WITH NORECOVERY", after that, restore the last differential backup and to finish, restore the log backups, for the last file you can use the option WITH RECOVERY to put the database Online.


    Regards,

    André César Rodrigues

    Please click the Mark as answer button and vote as helpful if this reply solves your problem. Thanks!

    Blog: http://sqlmagu.blogspot.com.br  LinkedIn:   

    • Marked as answer by '''HuuM''' Wednesday, July 17, 2013 1:47 PM
    Monday, July 15, 2013 2:27 AM
  • i am trying to mirror the database,

    i have restored the full database backuop

    now i need to restore diff back and log backup.

    can i please has so assistance, i am not sure how to do it.


    k

    As others suggested the way..its good follow it but little point here

    1.You dont necessariliy need to take differential backup and restore it for mirroring,take full backup and then recent transaction log backup.This will also do perfectly fine and will save time also.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, July 15, 2013 6:50 AM
  • Hello, incase if you are going to configure the mirroing then please see-

    Prerequisites, Restrictions, and Recommendations for Database Mirroring
    http://msdn.microsoft.com/en-us/library/ms366349(v=sql.105).aspx

    •When you are creating the mirror database on the mirror server, make sure that you restore the backup of the principal database specifying the same database name WITH NORECOVERY. Also, all log backups that were created after that backup was taken must also be applied, again WITH NORECOVERY.

     


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Monday, July 15, 2013 7:51 AM