Create backup of database using sql cursor

Published: 16 April 2017
on channel: Rajeev Ranjan Tiwary

380

This tutorial will help to create database backup very easily.
Codes used in this tutorial are:

DECLARE @databaseName NVARCHAR(50), @backupFilePath NVARCHAR(50),@backupFileName NVARCHAR(50),@dateOfFile NVARCHAR(20)
SET @backupFilePath = 'E:\Backup\'

SELECT @dateOfFile = CONVERT(NVARCHAR(20),GETDATE(),112) + REPLACE(CONVERT(NVARCHAR(20),GETDATE(),108),':','') --20170416165910
DECLARE cursorForBackup CURSOR FOR
SELECT name FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb','ReportServer','ReportServerTempDB')
OPEN cursorForBackup

FETCH NEXT FROM cursorForBackup INTO @databaseName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @backupFileName = @backupFilePath + @databaseName + '_' + @dateOfFile + '.BAK'
BACKUP DATABASE @databaseName TO DISK = @backupFileName
FETCH NEXT FROM cursorForBackup INTO @databaseName
END

CLOSE cursorForBackup
DEALLOCATE cursorForBackup

On this page of the site you can watch the video online Create backup of database using sql cursor with a duration of hours minute second in good quality, which was uploaded by the user Rajeev Ranjan Tiwary 16 April 2017, share the link with friends and acquaintances, this video has already been watched 380 times on youtube and it was liked by 10 viewers. Enjoy your viewing!

40,576

118