• Running out of space on the drive is a symptom, not the cause. You need to look past the symptom to see what caused it. Possible root causes would be lack of log backups, long running transaction, or replication/CDC/mirroring not processing the transactions.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]