Skip to content

Instantly share code, notes, and snippets.

@yusren

yusren/contoh.sql

Created February 19, 2024 02:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yusren/589de4ecf96175d90077f37664983204 to your computer and use it in GitHub Desktop.
Save yusren/589de4ecf96175d90077f37664983204 to your computer and use it in GitHub Desktop.
Download ZIP
QueryTimbanganBaru
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment