Backup Fail question
I am new to the forum ( and SQL almost a year in) so forgive me if I ask too many questions.
I was wondering if I am backing up multiple databases on a server in one back up job and say the 3rd back up fails will the job stop and NOT back up the rest of the databases? Below is the script from the back up job.
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [master,model,msdb,distribution,SMXP,emsl_Admin,emsl_Core,emsl_Replication,emsl_UnitReport,SMXPTemp,visualguarddb] TO DISK = ''\hqsql18g$SQLBackupsHQSQL8_PUBLISHERFullBackup<AUTO>.sqb'' WITH MAILTO = ''[email protected]'', CHECKSUM, DISKRETRYINTERVAL = 60, DISKRETRYCOUNT = 1, COMPRESSION = 2"'