Idera SQLSafe SP

-- 
-- SQLSafe Stored Procedure
-- Author: Tommy Bollhofer (thomas.bollhofer@chicos.com)
-- Last Modified: 04/28/05
--
-- Description: Performs a SQLSafe Full Backup
--

CREATE PROCEDURE usp_SS_FullBackup

@dbsvrname AS varchar(50),
@dbname AS varchar(50),
@path AS varchar(255),
@description AS varchar(255)
WITH ENCRYPTION
AS

DECLARE @currdate AS datetime,
    @datestr AS varchar(20),
    @filepath AS varchar(255)

SET @currdate = (select getdate())
SET @datestr = (select convert(char(8), @currdate, 112) + cast(datepart(hh, @currdate) as char(2))+ cast(datepart(mi, @currdate) as char(2)))
SET @filepath = @path +  @datestr + '.SAFE'

EXEC [xp_ss_backup] @database = @dbname,@filename = @filepath,@backupname = @dbname,@desc = @description,@init = 1,@compressionlevel = 100,@windowsusername = 'YOURWINDOWSACCOUNTHERE',@windowspassword = 'YOURPASSWORDHERE',@managementserver = 'YOURMGMTSERVERHERE';
GO