How to backup multiple SQL Server Databases in SQL Server

Example:
You need to take backup of multiple databases from SQL Server Instance and be created with date_time.

Below is a script you can use(Cursor);


USE MASTER
GO
DECLARE @BackupPath varchar(100)
--Provide the backup path
SET @BackupPath = 'C:\Backup\'
DECLARE @DBName AS varchar(200)

DECLARE Cur CURSOR FOR
--Change the select query for the DBs you like to backup
SELECT  name
FROM    sys.databases
WHERE   database_id >4  --(i.e excluding the following 'master, tempdb, model and msdb')

OPEN Cur
FETCH NEXT FROM Cur INTO @DBName
WHILE @@FETCH_STATUS = 0
BEGIN
  DECLARE @SQL varchar(max) = NULL
  DECLARE @DBNamewithDateTime varchar(128) = NULL
  SET @DBNamewithDateTime = @DBName + '_' + REPLACE(CAST(GETDATE()
       AS date), '-', '') + '_' + REPLACE(CAST(CAST(GETDATE() AS time)
       AS char(8)), ':', '')

  SET @SQL = 'BACKUP DATABASE [' + @DBName + '] TO  DISK = N''' +
              @BackupPath + '' + @DBNamewithDateTime + '.bak''
              WITH NOFORMAT, NOINIT,  NAME = N''' + @DBNamewithDateTime
              + '-Full Database Backup'',
                 SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10'

  PRINT @SQL
  EXEC (@SQL)
  FETCH NEXT FROM Cur INTO @DBName
END
CLOSE Cur
DEALLOCATE Cur