You may want to go easy and harder ways. Harder one is to use scheduled batch script. Easy is to use software, like mentioned before.
Edit and then schedule this script, so you can backup all existing databases:
REM Get date in format YYYY-MM-DD (assumes the locale is the United States)
FOR /F “tokens=1,2,3,4 delims=/ ” %%A IN (‘Date /T’) DO SET NowDate=%%D-%%B-%%C
REM Build a list of databases to backup
SqlCmd -E -S YourSqlServer -h-1 -W -Q “SET NoCount ON; SELECT Name FROM master.dbo.sysDatabases WHERE [Name] NOT IN (‘master’,'model’,'msdb’,'tempdb’)” > “%DBList%”
REM Backup each database, prepending the date to the filename
FOR /F “tokens=*” %%I IN (%DBList%) DO (
ECHO Backing up database: %%I
SqlCmd -E -S YourSqlServer -Q “BACKUP DATABASE [%%I] TO Disk=’F:Backup%NowDate%_%%I.bak’”
REM Clean up the temp file
IF EXIST “%DBList%” DEL /F /Q “%DBList%”
Note that you can mount remote location with
command to have a persistent drive letter.
Easy way is to use software that will automate backup process and add some features. The only software I used was Backup SQL Server Solution from EaseUs and Handy Backup Small Server. Last one is cheaper and easier to use (you can download fully functional trial and decide what plugins do you need).
I use batch script for my server and it is enough for me, but sometimes I wish my backups protected with encryption.