quick way of backing up every database on SQL ?

[Snow-Munki]

was just wondering if there was a quick way to backup every single one of my databases on SQL ?

atm I have a scheduled task to backup individual ones, but need to take a full backup tonight for the SP2 upgrade.

 

[Pho]

Just copy the data folder from within the installation directory. I've done before with MySQL but I'm sure MS SQL is the same.

MySQL - C:\Program Files\mysql\data
MsSQL - C\Program Files\Microsoft SQL Server\MSSQL\Data

If you want to restore a database just copy the relevant folders back in ..