use this script to make a backup strategy

--

use master

go

DECLARE @ServerNamevarchar(400)

DECLARE @DatabaseNamevarchar(400)

DECLARE @BackupPathvarchar(400)

DECLARE @TSQLCommandvarchar(2000)

DECLARE @FullBackupJobvarchar(2000)

DECLARE @DiffBackupJobvarchar(2000)

DECLARE @BackupDevicevarchar(2000)

DECLARE @FullStepNamevarchar(2000)

DECLARE @DiffStepNamevarchar(2000)

DECLARE @FullSchNamevarchar(2000)

DECLARE @DiffSchNamevarchar(2000)

SET @ServerName= HOST_NAME()

SET @DatabaseName= 'Database name'

SET @BackupPath= 'Unit:\Complete path\' + @DatabaseName...