Using cursors to back up a database in SQL SERVER2012

In SQL Server, to add a job, you can use the following statement to set up a regular backup database.

DECLARE @name VARCHAR (--databasename)

DECLARE @path VARCHAR (--pathforbackupfiles)

DECLARE @fileName VARCHAR (--filenameforbackup)

DECLARE @fileDate VARCHAR--usedforfilename SET @path = ' E:\Backup ' SELECT @fileDate =convert (varchar), GETDATE (), 112)

DECLARE db_cursor cursor for SELECT [name] from master.dbo.sysdatabases WHERE [name] not in (' Master ', ' model ', ' msdb ', ' Te Mpdb ')

OPEN db_cursor FETCH NEXT from Db_cursor to @name while @ @FETCH_STATUS =0

BEGIN

SET @[email protected][email protected]+ ' _ ' [email protected]+ '. BAK '

BACKUP DATABASE @name to [email protected]

FETCH NEXT from Db_cursor to @name

END CLOSE Db_cursor

Deallocate db_cursor

-----------------------

DECLARE @name VARCHAR (--databasename)

DECLARE @path VARCHAR (--pathforbackupfiles)

DECLARE @fileName VARCHAR (--filenameforbackup)

DECLARE @fileDate VARCHAR--usedforfilename Set @name = ' dbname ' Set @path = ' E:\ ' SELECT @fileDate =convert (VARCHAR), GETDATE (), @[email protected][email protected]+ ' _ ' [email protected]+ '. BAK ' BACKUP DATABASE @name to [email protected] ------------------------