• You can also use the TABLOCK hint so that DBCC CHECKDB does not create internal snapshots. More details here[/url]

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga