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