Switch Recovery Model Simple to Full.

Hi all recently I found one interesting fact in Sql Server related to recovery model.As we are aware if we change the recovery model full to simple then we have to take full  backup else our differential and transaction backup will start fail.

What you think this is right statement right??

But its not mandatory to take full backup we can take differential backup and it will work the only thing is the pointer should be match with last full backup or differential backup .

You can use below query to check pointer is matching last full backup or not.

SELECT name,
       backup_start_date,
       TYPE,
       first_lsn,
       database_backup_lsn
FROM msdb.dbo.backupset
WHERE database_name = 'your db name';

 GO

I have simulated the same scenario as per my question and its working as well I am taking only differential backup after changing the recovery model simple to full and its success for all t-log backup .