• Declare @path Varchar(200)

    set @path='xxxx'+ CONVERT(VARCHAR(10),GETDATE(),110)+'.bak'

    BACKUP DATABASE [xxxx]

    TO DISK = @path