We're using Backup all databases on a server script by Nigel Rivett from http://www.nigelrivett.net/BackupAllDatabases.html. Created backup files that are picked up by regular network backup and copied to tape.

>To backup an SQL database, is it suffcient just to copy out the .MDF and .LDF files.
>(I tried to restore from these recently but ran into problems )