Hi again,Now I've got some daily check scripts sorted which I'm running manually on (initially) 3 different servers I'd like to do a bit of automation. What I'm doing at the moment is changing the connection manually each time and running this:--Free space by drive: EXEC master..xp_fixeddrives--Last backup date. SELECT B.name as Database_Name, ISNULL(STR(ABS(DATEDIFF(day, GetDate(), MAX(Backup_finish_date)))), 'NEVER') as DaysSinceLastBackup, ISNULL(Convert(char(10), MAX(backup_finish_date), 101), 'NEVER') as LastBackupDate FROM master.dbo.sysdatabases B LEFT OUTER JOIN msdb.dbo.backupset A ON A.database_name = B.name AND A.type = 'D'
Which obviously gives free space per drive and last backup date.How do I go about scripting this so it connects to the 3 different servers one at a time (eg Server1, Server2 & Server3) and updates the tables in my DB I've created on my local machine? (I'll be creating a report in reporting services with this data) Hope that makes sence!
Script Across multiple connections
Posted - 2010-03-18 : 12:49:27
