Tag Archives: SQL Server 2008 R2

When I Drop a Database, Why Does 1 Or More Files Still Exist?

This is a quick post about an issue we have encountered a couple of times when drop a database and one or more files appear to be left over for some time afterwards. This time, we found the culprit! Essentially, … Continue reading

Posted in SQL Server Issues | Tagged , , , , , | Leave a comment

TSX to MSX Connection Errors After Upgrading to SQL Server 2008 R2

Problem After upgrading your TSX SQL Server 2005/2008 to SQL Server 2008 R2, you may experience some connectivity issues between your newly upgraded TSX server and your MSX server.  If you see the below error in the SQL Server Agent … Continue reading

Posted in SQL Agent Multi-Server Administration, SQL Server 2008 R2 Upgrade | Tagged , , | Leave a comment