All database backup in a single query

[Hemant Pathak]

Use this query to get a whole backup of your database

USE MASTER
DECLARE @dbName varchar(100) 
DECLARE @dbPath varchar(100) 
DECLARE dbName_Cur CURSOR FOR
SELECT	Name FROM SYSDATABASES WHERE SID<>0x01
OPEN dbName_Cur
FETCH NEXT FROM dbName_Cur
INTO @dbName
WHILE @@FETCH_STATUS=0
	BEGIN
	-- HERE SET YOU BACKUP FOLDER NAME
	SET @DBPATH='C:\RND\'+@dbName+CONVERT(VARCHAR,GETDATE(),112) +'.bkp'	
	BACKUP DATABASE @DBNAME TO  DISK = @dbpath WITH  INIT, NOUNLOAD,NAME = N'CHKBKP',NOSKIP,STATS = 10,NOFORMAT
	FETCH NEXT FROM dbName_Cur
	INTO @dbName
	end;
CLOSE dbName_Cur
DEALLOCATE dbName_Cur
PRINT 'Completed..........'
GO