gipasoft

Database backup

Nov 22nd, 2016
279
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.18 KB | None | 0 0
  1. -- Database backup
  2.  
  3. USE [Ancescao]
  4. GO
  5. /****** Object:  StoredProcedure [dbo].[BackupDatabase]    Script Date: 22/11/2016 16:40:49 ******/
  6. SET ANSI_NULLS ON
  7. GO
  8. SET QUOTED_IDENTIFIER ON
  9. GO
  10. ALTER PROCEDURE [dbo].[BackupDatabase]
  11.         @dbname VARCHAR(50)
  12. AS
  13. BEGIN
  14.         SET NOCOUNT ON;
  15.         IF      (EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname)))
  16.                 BEGIN
  17.                         DECLARE @path VARCHAR(256);
  18.                         DECLARE @fileName VARCHAR(256);
  19.                         DECLARE @currentDate VARCHAR(50);
  20.                         SET @path = 'E:\gestionale\backup\';
  21.                        set @currentDate=REPLACE(REPLACE(REPLACE(CONVERT(CHAR(16),CURRENT_TIMESTAMP, 120), '-', ''), ' ', ''), ':', '');
  22.                        SET @fileName = @path + @dbname + '_' + @currentDate + '.BAK';
  23.                        Print 'Backup fileName ' + @fileName;
  24.                        BACKUP DATABASE @dbname TO DISK = @fileName;
  25.                end
  26.        else
  27.                PRINT 'DATABASE ' + @dbname + ' NOT found';    
  28. END
  29.  
  30. -- Run Store Procedure
  31. EXEC dbo.BackupDatabase @dbname = 'Ancescao';
Advertisement
Add Comment
Please, Sign In to add comment