In order to backup SQL backup from SQL Management using the SQL Agent.


1. First you will go to SQL Management Studio on your computer and connect to your SQL Environment as your SA user. 


2. Next you expand SQL Server Agent and Right Click on Jobs and Click New Job



3. In General Tab you can Give your Job a Name


4.In Steps you will Click New...


5.In the New Job Step Window you will give the job a Step Name and in the command window Post the follow Script(see below) and once done click OK

=================================================================================

--Script 3: Backup all



--1. Variable declaration


DECLARE @path VARCHAR(500)

DECLARE @name VARCHAR(500)

DECLARE @filename VARCHAR(256)


-- 2. Setting the backup path


SET @path = 'C:\Backup\'   -- this can be any path you would like but make sure the folder exists in the location you pick


-- 4. Defining cursor operations



DECLARE db_cursor CURSOR READ_ONLY FOR

SELECT name

FROM master.dbo.sysdatabases

WHERE name NOT IN ('master','model','msdb','tempdb')


--5. Initializing cursor operations

OPEN db_cursor


FETCH NEXT FROM db_cursor INTO @name


WHILE @@FETCH_STATUS = 0


BEGIN


-- 6. Defining the filename format



SET @fileName = @path + @name + '.BAK'


BACKUP DATABASE @name TO DISK = @fileName WITH INIT


FETCH NEXT FROM db_cursor INTO @name


END


CLOSE db_cursor


DEALLOCATE db_cursor

================================================================================


5. In the Schedules Window Click New..


6.In the New Job Schedule Window you will give your Schedule a name and schedule the daily local backup and once done click OK


7. Once you have configured this you can Setup Alerts and Notifications as required otherwise just click OK


8. Once done you can then follow the steps in the FAQ Folder Selection to make sure you add the SQL Backup Folder to your backup. 


Please contact support if you require any assistance with the configuration of SQL backups.