This is what I have written and using it for a while. I have scheduled this as job and I also use it on adhoc basis.

CREATE   PROCEDURE dbo.SP_DBA_BACKUP_PROC_FULL

AS

BEGIN

/************* ALTERd BY: Raman...