Tuesday, November 15, 2011

Dedicated Administrator Connection (DAC) in SQL Server 2008 R2

In Microsoft Windows, we have Safe Mode. In SQL Server 2008, we have the Dedicated Administrator Connection, or DAC. We can use DAC to obtain emergency access to a SQL Server 2008 database instance in cases where the instance is blocked up, locked up, or just plain hosed.

Full article : 4sysops.com