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”
LinkedServer Failure — SPN not set
Recently, I tested a LinkedSErver and received the error: “The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) (mscorlib)”
What does this mean? Continue reading “LinkedServer Failure — SPN not set”
SQL PASS Rally
May 11, 12, 13. Steve is presenting on performance tuning in Orlando.