Perry Whittle (11/28/2012)
raotor (11/28/2012)
2. Why ever destroy the existing chain by performing a second full backup other than for purely space or management reasons?Full backups DO reset the Differential Base LSN, so the only chain they break is for differential backups not for transaction logs.
I have a test scenario running where I'd performed an initial full backup last week and then performed a log backup every hour.
Today I performed a second full database backup after thinking I wouldn't destroy the chain and now I cannot restore the database to a point in time before the most recently performed full backup done today, so hasn't the chain been broken if that's the case?