winston Smith (4/11/2013)
Ive set up mirroring many times with a full backup and a log backup or two.Someone mentioned recently that you can set it up using a full backup, diff backup and any tran logs since the diff backup.
But this does not make senese to me as diff backups dont advance the log chain. I assumed that if i took a diff backup, and then took a log backup, they would both start from the same point. is that incorrect?
To add to Gail, differential backups do advance the diff base LSN and hence are used in combination with log backups as Gail has mentioned.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉