sp_Backup permits to automate the task of Backup of the Databases taking a Dump of all the existing bases on a device of Dump. The SP it should be to generate in Master and it can be put as Scheduled Task. Because it reads the databases from sysdatabases, avoids to update the sp when databases are created or eliminated.
For SQL Server 6.5
Author: Ricardo Pistarino
Disclaimer: We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
"as -is", without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose...
Back to Database Journal Home