Creating an automated database backup by means of SQL Server Agent Job

Task: to create a fully automatic database backup system by means of SQL Server Agent Job with an e-mail fails notification subsystem EXEC [master].[dbo].[sp_addumpdevice] @devtype = N’disk’, @logicalname = N’AdventureWorks2008R2′, @physicalname = N’D:\SqlData\MSSQL\Backup\AdventureWorks2008R2.bak’ GO Source code 1: SSMS -> Object Explorer -> [sql_server_instance] -> Server Objects -> Backup Devices -> AdventureWorks2008R2 EXEC [master].[dbo].[sp_configure] ‘show advanced [...]