#100000
Yesterday I was attaching a daasbate but SQL Server is throwing out an error (compression issue). I asked for help at twitter, and the tweeps sent me to various online resources (I focused on Paul Randal's blog). Research, read, Research, read test research read test I was running out of clues!Then I came across a forum post that suggests I check the data file's properties and see if it is marked Compress contents to save disk space (I unticked it). That solved the issue. I ran DBCC CHECKDB and the daasbate was ok! Talking about overlooking
