Today some architecture changes were scheduled to occur in the evening. I wanted to adjust or disable backup jobs that could be affected. I have some 50 SQL servers. I needed to know when the backups were to start on each server. I found a nice script at http://www.mssqltips.com/tip.asp?tip=1622to do that for a single server. Continue reading “Determine Backup schedules across multiple SQL Servers”
» Get Alerted when your 2005 SQL cluster fails over
Today, I want to show how to be alerted any time one of your clustered SQL 2005 server fails over. This will work whether some admin fails it over on purpose, or accidentally.
Continue reading “» Get Alerted when your 2005 SQL cluster fails over”
Ways to run SSIS packages (and their 64/32 bit impact):
What ARE the ways to run SSIS packages? Actually, I can think of 5…
Continue reading “Ways to run SSIS packages (and their 64/32 bit impact):”