Idera SQLSafe SP

,

Useful for Idera SQLSafe backups. Great software but the GUI and maintenance plan generation are a little quirky. You can easily modify this for Full, Log, Encryption, etc. - Example:

EXEC usp_SS_FullBackup @dbsvrname='YOURSERVERNAME',@dbname='Northwind',@path='C:\Northwind_Full_',@description='Full Backups for Northwind'

-- 
-- 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

Rate

1 (1)

Share

Share

Rate

1 (1)