The script allows to backup all databases if a SQL-Server Instance. It determine the backup-path by the environment variable DBBackupPath of the operating system. It also determines the SQL-Server instance on which it runs and uses the corresponding path.
1.) Create a Backup-Folder on the Server. The last part of the path must be "Backup"
(e.g. f:\MSSQL2005\Backup)
1a.) If there is a SQL-Server instance installed on the server the instancename must be previous before "Backup" (e.g. f:\MSSQL2005\Instance_Name\Backup
2.) Set the environment variable "DBBackupPath" to this folder
3.) Run the script by scheduler (ISQL/OSQL) or SQL-Query
