April 11, 2012 at 1:51 pm
I'm trying to set up database mirroring on my local. Is only a full backup sufficient or do I need to backup and restore the log as well?
I was going through an article and was confused(points 2 and 5) when the author mentioned:
(1)Perform a full backup of the database on the Principal server.
(2)Perform a Transaction Log backup on the Principal server.
(3)Copy the backup file to the Mirror.
Important: Do a restore of the full backup into a new step, but before doing the restore, go to Options, then ensure you check the No Recovery option! This is vital!
(4)Perform another restore of the Transaction Log, also with the No Recovery option. (This is important, otherwise you'll get an error when starting the mirror - See Gotchas section for explanation).
http://www.codeproject.com/Articles/31325/Step-by-Step-SQL-Mirroring-the-ASPState-Database
April 11, 2012 at 2:01 pm
My experience setting up mirroring required a full backup and then a transaction log backup from the principal database.
I have had another DBA say the t-log wasn't needed, but I would do it to be certain.
April 11, 2012 at 2:49 pm
I can confirm you need the log backup restored as well.
---------------------------------------------------------------------
April 12, 2012 at 1:28 pm
george sibbald (4/11/2012)
I can confirm you need the log backup restored as well.
+1
April 12, 2012 at 1:38 pm
Always On in 2012 works the same, one full backup and restore followed by at least one t-log backup and restore. More importantly bear in mind this scenario
full backup at 4:00pm and is restored to mirror
t-log backup at 4:10pm and restored to mirror
an admin takes a manual log backup at 4:20pm
an auto scheduled backup occurs at 4:30pm
at 4:45pm you want to start the mirror session.
Before doing so you must restore the backups from 4:20pm and 4:30pm 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply