We have a client who has SQL Express 2014 and wanted to automate backups. Please find the steps to create automated backups using SQL Express 2014.
Step 1: Open SQL Server 2014 Express
Step 2: Expand Server Objects
Step 3: Right Click on Backup Device and select New Backup Device.
Step 4: The Backup Device Popup window will appear
a./ Enter Device name
b./ Enter the destinations of the backup files
c./ Select Ok.
Step 5: Right click on the Backup Device you have just created and select Backup Up a Database.
Step 6: Select the database you wish to backup up from under source
Step 7: Select the script option.
Step 8: Select Ok.
Step 9: Save the Script to a file location of your choice.
Step 10: Create a batch file with the following information text:
sqlcmd -E -S [SERVERNAME]\[SQLINSTANCE] -i [LOCATIONOFSQLSCRIPT]
Step 11: Setup a Schedule Task to run the batch file on a nightly basis.