Third result for "sql server script database backup":
Simple script to backup all SQL Server databases[/url]
If you're uncomfortable with backup scripts, you can always try a maintenance plan.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP