giammin

Backup Database stored procedure

Jan 16th, 2013
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.68 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[BackupDatabase]
  2.     @dbname VARCHAR(50)
  3. AS
  4. BEGIN
  5.     SET NOCOUNT ON;
  6.     if  (EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname)))
  7.         Begin
  8.             DECLARE @path VARCHAR(256);
  9.             DECLARE @fileName VARCHAR(256);
  10.             Declare @currentDate varchar(50);
  11.             SET @path = 'D:\Backup\SqlServer\';
  12.             set @currentDate=REPLACE(REPLACE(REPLACE(CONVERT(CHAR(16),CURRENT_TIMESTAMP, 120), '-', ''), ' ', ''), ':', '');
  13.             SET @fileName = @path + @dbname + '_' + @currentDate + '.BAK';
  14.             Print 'Backup fileName ' + @fileName;
  15.             BACKUP DATABASE @dbname TO DISK = @fileName;
  16.         end
  17.     else
  18.         PRINT 'database ' + @dbname + ' not found';
  19. END
Advertisement
Add Comment
Please, Sign In to add comment