Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
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"
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
Backup whole instance
How to backup and restore an entire SQL Server 2005 instance, not just the individual databases.
Restore Backup into Named Instance
Server to server backup
Named SQL Server Instance