• Jeff Moden (7/9/2014)


    hoping that you'd explain how your previous company managed to make it so on a 1TB database.

    Maybe I'm missing something, but the way I did it (SQL 2005) when I worked at the bank was DBCC CheckDB ('Database name') with no_infomsgs, all_errormsgs

    DB hit 1.2 TB at its largest, no problems with CheckDB creating its snapshots.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass