July 14, 2013 at 6:55 pm
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy