You can get help from your DBA

DBA can give access on development box to run SQL profiler and DTA or assist doing this work

Thanks

Dave

Thanks Jason

Ok, thanks

thanks for the quick replies guys, I just tested my work using the below steps and it worked

http://blog.jitbit.com/2010/04/moving-sql-table-textimage-to-new.html

thx again for all your help

Dave

Hi,

Sorry about the late reply,(I was busy with year end work)

well I found the problem , In the table I have a text column 6000 long, Part of...

Problem, it is still not solved

After running all the above steps, I checked table properties:

Under table properties --> storage the I can see the file group is "new_FG"

Row count...

Thanks good point, I will keep this in mind

the test DB is 20GB but the Prod is 600GB

One more question

Do I need to shrink the DB after completing the task ?

Thanks I just tested it with 20GB Database and it is working now

Yes no no need to drop FK you are right

this morning I was playing with 5MB DB...

Ok

Hi,

I have a similar situation and just need to clarify few thing, Instead of starting a new thread I'm using the old one, hopefully no minds 🙂

Following are the...

Yes, thanks for your help

I build the package using Import Wizard and then modified it

Ok, thanks

I think I'm able to use Export wizard and save as SSIS package, correct ??

But going back to your suggestions I think the quickest thing is SSIS...

I think I'm able to use Import/Export and save as SSIS package and then run it after every 5 minutes

Please let me know, what I'm thinking is correct or not

Thanks Chris

I just want an expert advise before doing this