Use PowerShell to Backup All User Databases
This script will back up all user databases – you need to change the BWOODY1SQL2K8 part to your serverinstance name, and of course, you should only run this on a test system until you completely understand it. Unfortunately, the SQL Server PowerShell Provider doesn’t make this very easy – and there may be a better way to do this once I research it more. Also – this script was adapted from one given to me earlier, and unfortunately I don’t recall the source
See the rest here:
Use PowerShell to Backup All User Databases
