Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[BackupDatabase]
- @dbname VARCHAR(50)
- AS
- BEGIN
- SET NOCOUNT ON;
- if (EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname)))
- Begin
- DECLARE @path VARCHAR(256);
- DECLARE @fileName VARCHAR(256);
- Declare @currentDate varchar(50);
- SET @path = 'D:\Backup\SqlServer\';
- set @currentDate=REPLACE(REPLACE(REPLACE(CONVERT(CHAR(16),CURRENT_TIMESTAMP, 120), '-', ''), ' ', ''), ':', '');
- SET @fileName = @path + @dbname + '_' + @currentDate + '.BAK';
- Print 'Backup fileName ' + @fileName;
- BACKUP DATABASE @dbname TO DISK = @fileName;
- end
- else
- PRINT 'database ' + @dbname + ' not found';
- END
Advertisement
Add Comment
Please, Sign In to add comment