locked
restoreing database for mirroring RRS feed

  • Question

  • i have 123Gig of database,

    i am trying to setup mirroring for it.

    we take full backup every week and diff backup every night, and trans log every hour.

    and last full database backup was taken  2 days ago and we have diff backups since last full backuop.

    what should be the restore strategy for mirrored database.

    Please advise


    k

    Monday, July 15, 2013 12:52 AM

Answers

  • Need to restore as per below order.

    1. Full Backup  with norecovery

    2. Recent Differential Backup (not all the differential backup taken after full backup) with norecovery

    3. All log backup taken after recent Differential backup with norecovery


    Srinivasan

    • Marked as answer by '''HuuM''' Monday, July 15, 2013 1:55 PM
    Monday, July 15, 2013 4:28 AM

All replies