Greetings,

I am trying to move an existing table to a separate file group. I have
set up the new file group and an mdf file within that file group on a
separate disk. My problem is that I keep getting consistency errors when
I use dbcc checktable('blah') after I moved the tables to the new file
group / mdf data file.

I am curious to know if anyone else has had any trouble with this
scenario?

Thanks,

Michael

MS Sql Server LazyDBA home page