How do I enable DAC on a clustered SQL Server 2008 after I can no longer connect to SQL Server in any other way
I'm having issues with SQLServer 2开发者_运维技巧008 where a Server level triggered was not dropped correctly.
Articles on the web recommend dropping them through the DAC.
However, the DAC is disabled by default on Clustered environments.
How do I enable the DAC bearing in mind that I can no longer connect to the SQLServer 2008 instance in any other way.
cheers
andy
According to this article the only other alternative to drop these triggers is to stop your server and restart it using the minimal configuration mode. You can obviously then enable the DAC.
精彩评论