Moving a table with image field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris White - 30 Dec 2008 23:46 GMT

I read on another website that you can not move a table with a text or image field in it, is this correct? If so what is the best way to re-create the table in a new filegroup? This one table is using 85% of my database and we want to move it to another set of disk-drives. Current size 165GB and growing daily.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Reply to this Message

John Bell - 31 Dec 2008 16:00 GMT

>I read on another website that you can not move a table with a text or
>image field in it, is this correct? If so what is the best way to
[quoted text clipped - 4 lines]
> EggHeadCafe - .NET Developer Portal of Choice
> http://www.eggheadcafe.com

Hi

If you creaated a clustered index on the new filegroups all data except the
text type columns (text, ntext, varchar(max) etc.. ) would move. If you need
to move all columns then create a new table on the new filegroup and move
the data across.

John

Reply to this Message