i wrote a job to backup my server
but because of my hard disk limittition i want to write another job to compress my bak files and delete files that are older than 20 days .
my first job is :
Code:
declare @path nvarchar(1000) set @path='D:\MySolution\data\BackUp\Auto\mainserver_'+convert(nvarchar(10),getdate(),112)+'.bak' BACKUP DATABASE [mainserver] TO DISK =@path