• First problem there, the database snapshot for CheckDB can't be created. Is that an NTFS drive, does the SQL Server service account have full permissions to the folder with the data files?

    Is it Enterprise edition?

    Are you running any disk-related filter drives (eg DiskKeeper, etc)

    Second problem is the corruption, but need to see a full list to help there. Can you take the DB into single user mode and run the following?

    DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLOCK

    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