EXEC sp_MSForEachDB
'IF ''?'' NOT IN (''tempdb'')
BEGIN
PRINT ''''
PRINT ''''
DBCC checkdb (''?'')
PRINT ''''
PRINT ''''
BACKUP DATABASE [?] TO DISK = N''c:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\?.bak''
WITH RETAINDAYS = 3, NOFORMAT, NOINIT, NAME = N''? - Completo Database Backup'', SKIP,
NOREWIND, NOUNLOAD, STATS = 10
END'
Su SQL2000 non funziona :(
