HOW TO BACKUP ALL DATABASES IN SQL SERVER




This is a SQL script of get all Databases Backup in particular folder.
backup file name will be "DataBaseName_{Month}_{Date}_{Year}.bak"

Notes :

1) Current user have full access of backup database.
2) Remote drive setup is extra step you have to perform in sql server in order to backup your dbs to remote drive. 
3) you have to chnage you sql server accont to a network account and add that user to have full access to the network drive you are backing up to.