How To create One or more Database Backup in Loop using Sql server Cursor

How To create more Database Backup in Loop using Sql server Cursor and Backup Database Command to create Backup

How To Get Database Backup using cursor and also only write down this code

Backup Database  "database name"   To Disk = "pathname"

DECLARE @name AS VARCHAR(50) DECLARE @FileName AS VARCHAR(50) DECLARE @filedate AS VARCHAR(50) SELECT @filedate =CONVERT(VARCHAR(20),GETDATE(),112) DECLARE Db_cursor CURSOR FOR SELECT * NAME FROM MASTER.dbo.sysdatabases WHERE NAME NOT IN ('master','model','msdb','tempdb') OPEN Db_cursor FETCH NEXT FROM Db_cursor INTO @name WHILE @@FETCH_STATUS = 0 BEGIN SET @FileName = 'E:\dhaval\' + @name + '_' + @filedate + '.Bak' BACKUP DATABASE @name TO DISK = @FileName END

And if you want to Restore it then write down this code

Set Single
Restore Database "Database Name" From Disk = "Path name"
Set Multiple


Set single and means single user database  restore .then first of set single and database has restored then make multiple User.