--- For Full Backup

BACKUP DATABASE AWSample
TO DISK = 'E:\BackupData\AWData1.BAK'
-- Changed some data
BACKUP LOG AWSample
TODISK='E:\BackupData\AWLOG_1.trn'
WITH INIT
-- Assume user delted something that he shouldn't do 
BACKUP LOG AWSample
TODISK='E:\BackupData\AWLOG_Tail.trn'
WITH INIT

--- So I start restoring my DB
RESTORE DATABASE AWSample
FROM DISK='E:\BackupData\AWSData1.bak'
WITH NORECOVERY
-- And I just restore till 1st Log backup as it has data which I am want
RESTORE LOG AWSample
FROM DISK 'E:\BackupData\AWLog_1.trn'
WITH NORECOVERY

RESTORE DATABASE AWSample
WITH RECOVERY

---- DO so same above process For File Group

-- I am taking backup of filegroup FG1
BACKUP DATABASE AWSample
FILEGROUP='FG1'
TODISK = 'E:\BackupData\AWSFG1.BAK'
-- Changing some data
BACKUP LOG AWSample
TODISK='E:\BackupData\AWLog_2_1.trn'
WITH INIT
GO
-- Again assume user delted something that he shouldn't do 
-- So I take TAIL LOG Backup
BACKUP LOG AWSample
TODISK='E:\BackupData\AWLog_2_TailLog.trn'
WITH INIT
GO

-- And start to restore DB
RESTORE DATABASE AWSample
FILEGROUP='FG1'
FROM DISK='E:\BackupData\AWSFG1.bak'
WITH NORECOVERY

-- Now, Transaction Log Backup 1 has all what I need
RESTORE LOG AWSample
FROM DISK 'E:\BackupData\AWLog_2_1.trn'
WITH NORECOVERY
-- But untill I restore this Tail Log Backup, I wont be able to access FG1
RESTORE LOG AWSample
FROM DISK 'E:\BackupData\AWLog_2_TailLog.trn'
WITH NORECOVERY

RESTORE DATABASE AWSample
WITH RECOVERY