yes i did but i am looking for a script which move tables from primary file group to secondary file group.

or i can put it this way..

I would like to...

How sql server will take care of moving an existing table to a new ndf file?

I am just trying to split my 1 TB database into 2 drives so that i can accomodate it effectively without any issues after few weeks as it grows rapidly...

I am just trying to give db_reader and db_writer to a group which i have been doing sincea while but not its acting weired, i have no clue why sql...

I am still not sure where to start, can some one script out for me as i have given my requirement. just trying to be safe.

I have a table (200GB) with 8 indexes and want to move this to the new data file. Do i need to recreate all the indexes again on the secondary...

I didnt check that option on litespeed where is it?

anyways hows does that help restoring all tables orrestoring database would be same for me.

I didnt get what you are trying to say, do we really have any issues moving data between the data files. But stilli can have a downtime thats not a...

what is it locking??

we may not need diffrential backups as we do our updates only once a month. and ofcourse we do all our backups with Litespeed.

I still didnt get any comments on...

instead doing this can we do with a cursor or some CTE's ?? just in case.

I think still it will not work because i have nearly 140 ndf files and it will be more than 4000 strings.

is there any other way where it can loop...

Now i have this from my print mesg

EXEC master.dbo.xp_restore_database @Database = 'RevBudget', @Filename = "\\OBBEAVER\PA\RevBudget.BAK", @WITH = 'move "2004_01_PA" to "F:\SQL_DATA\RevBudget_2004_01_PA_data.ndf"', @WITH = 'move "2004_02_PA" to "F:\SQL_DATA\RevBudget_2004_02_PA_data.ndf"', @WITH = 'move...

still i get the same error:

here is the print..

yeah..i think my bak file name is duplicated.

Roust_m

I still get this error again and again, is there any thing worng in the syntax or anything else..

Msg 105, Level 15, State 1, Line 1

Unclosed quotation mark after the...