MS SQL Database Backup Script

Besides using Database Maintenance Plan to create automatic backup of critical database, you can simply use the below script and call it regularly as Scheduled Jobs inside SQL Server Agent

BACKUP DATABASE [MYDB]

  TO  DISK = N'Z:\RestoreData\MYDB.BAK'

   WITH  INIT ,  NOUNLOAD , 

   NAME = N'MYDB backup',  NOSKIP ,  STATS = 10,  NOFORMAT