--Sao Luu Full
BACKUP DATABASE Database_Name
TO DISK = 'E:\HUY\Backup\3in1.bak'

--Sao Luu Diff
BACKUP DATABASE Database_Name
TO DISK = 'E:\HUY\Backup\3in1.bak'
WITH DIFFERENTIAL

--Sao Luu Tail_Log
BACKUP LOG Database_Name
TO DISK = 'E:\HUY\Backup\3in1.bak'
WITH NO_TRUNCATE

--Khoi phuc file full
RESTORE DATABASE Database_Name
FROM DISK =  'E:\HUY\Backup\3in1.bak'
WITH FILE  = 1,NORECOVERY
-> file 1 chứa file full

--Khoi phuc file differential
RESTORE DATABASE Database_Name
FROM DISK =  'E:\HUY\Backup\3in1.bak'
WITH FILE = 2,NORECOVERY
-> file 2 chứa file diff

--Khoi phuc file tail_log
RESTORE DATABASE Database_Name
FROM DISK =  'E:\HUY\Backup\3in1.bak'
WITH FILE = 3,RECOVERY
->file 3 chứa file taillog