use this script to make a backup strategy

--

use master

go

DECLARE @ServerName varchar(400)

DECLARE @DatabaseName varchar(400)

DECLARE @BackupPath varchar(400)

DECLARE @TSQLCommand varchar(2000)

DECLARE @FullBackupJob varchar(2000)

DECLARE @DiffBackupJob varchar(2000)

DECLARE @BackupDevice varchar(2000)

DECLARE @FullStepName varchar(2000)

DECLARE @DiffStepName varchar(2000)

DECLARE @FullSchName varchar(2000)

DECLARE @DiffSchName varchar(2000)

SET @ServerName = HOST_NAME()

SET @DatabaseName = 'Database name'

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