July 15, 2008 at 8:37 am
hay all.
my case is the following:
i have a database with one filegroup, its tables have a text columns.
what i need to do is to create anther file group and a second file , then move the text filed to the second file group.
the way am working no is:
1- Create a copy of the target table on the second file group.
2- insert the data from the source table to the new one.
3- drop the old table.
4- rename the newly created table.
my question is:
dose the text fileds still be working, or the pointer will point to a different location??
..>>..
MobashA
July 15, 2008 at 2:39 pm
I dont see where you updated the value for TEXT\Image filegroup to point to the new filegroup.
I am assuming you are trying to get your blobs pages away from your non blob filegroup. I dont think your approach will work, you will just move all the data to a different file group.
The only way to to this is either via the GUI or recreate a staging table in the old file group with the TEXTDATA ON syntax and then copy your data into the stagin table then rename the staging table to the live table name. This is the same thing the gui does when you set the text property but I dont like for SSMS to go to sleep for a long time.
BTW this could take forever depending on the amount of existing data. Forever quantified as hours and hours and hours.
July 15, 2008 at 3:50 pm
am testing the modificaton it takes at least 3 hours..
..>>..
MobashA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply