Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Database backup
- USE [Ancescao]
- GO
- /****** Object: StoredProcedure [dbo].[BackupDatabase] Script Date: 22/11/2016 16:40:49 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER 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 = 'E:\gestionale\backup\';
- 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
- -- Run Store Procedure
- EXEC dbo.BackupDatabase @dbname = 'Ancescao';
Advertisement
Add Comment
Please, Sign In to add comment