MSSQLServer database-Job scheduling scheduled backup database

Job scheduling and backing up the database is a common behavior, and mastering these two techniques is very necessary for me.

Find this example on the Internet and record it here

SQL statement to back up the database

--automatically backs up and saves the last 5 days of SQL database job scriptsDECLARE @filename VARCHAR(255)DECLARE @date DATETIMESELECT @date=GETDATE()SELECT @filename = 'g:\ storage location \ Database name-'+CAST(DATEPART(yyyy,@date) as varchar)+'-'+CAST(DATEPART(MM,@date) as varchar)+'-'+CAST(DATEPART(DD,@date) as varchar)+'. bak'BACKUP DATABASE [Database name]  to  DISK = @filename  withINITGO DECLARE @OLDDATE DATETIMESELECT @OLDDATE=GETDATE()-5EXECUTEMaster.dbo.xp_delete_file0N'g:\ Storage location'N'Bak',@olddate,1

Just opened the SQL Server Agent service, in fact, my own understanding is a timer, constantly perform some operators assigned to his task, a bit like the alarm clock feeling, see my demonstration steps

　　The first step

　　

Step Two

Step Three

Fourth Step

Fifth Step

MSSQLServer database-Job scheduling scheduled backup database