|
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
| 
