QueryTimbanganBaru

contoh.sql

ALTER PROCEDURE [dbo].[sp_backup_db]
		@createdBy varchar(50)
AS BEGIN
		SET NOCOUNT ON

		declare @tgl datetime = getdate()
		, @fileName varchar(200)
		, @dbName varchar(200)

		select @dbName = DB_NAME() 
		set @fileName = 'E:\DB_Backup\ELEMEN4\AUTO_BACKUP_BY_'+ upper(@createdBy) +'_'+ upper(@dbName) +'_' + replace(convert(varchar(19), @tgl, 120), ':', '.') + '.BAK'
		BACKUP DATABASE @dbName TO DISK = @fileName
		
		select @fileName as filepath;
END;