After switching from TSM to Veeam, I found myself wasting plenty of hours excluding OFF-Line sql databases from backup.
Normally it demands that you start SQL Server Management Studio ( witch takes a war ), identify the correct instance and then exclude the ofline databases in each backup job…..
However… I’m notorisly lazy and in a bright moment, I turned to Powershell.
The resulth is a script telling me if a database is offline and therefore maybe should be excluded or if a database in online and can be included in backup, and best of all… without starting SQL Server Management Studio.
The script is eacy to use, gives a nice overview, you can in / exclude a database on a server in less than 20 sec ( depends on how many instances / databases the script have to scan ), you can chose to exclude Logs and diff backup and only have FULL backup if needed, and at last, - it logs every change make by time and username.
Script is free to use…
regards MACH0NE
