Post reply

restoring databae to setup Mirroring

  • July 14, 2013 at 6:55 pm

    #279906

    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

  • July 14, 2013 at 10:50 pm

    #1632285

    Restore FULL, latest DIFF, and all transaction log backups for the day, all WITH NORECOVERY. Then create the mirror before the next log backup occurs.

    Also, you should be testing the restore of your backups and know how to restore to a point in time in case of failure.

  • July 15, 2013 at 7:56 am

    #1632471

    Thanks its resolved

Viewing 3 posts - 1 through 2 (of 2 total)

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