Move File contents to other

Question

Move File contents to other

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
April 13, 2012 at 1:53 pm

#272589

Hi,
1. How to move one filegroup content to the other filegroup using syntax? Is this just a simple alter statement?
2. In a datafile group, there are 4 files which are set as - default.
Now once the data starts flowing in to this filegroup how this will be used /filled in the files? Does this happen like parallel insertion of the records in each file or first it complete entering the data in first file followed by moving into other files?
Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

1) Rebuilds the indexes that you want to move and specify ON <desired filegroup>, and remember that the clustered index is the table.

2) Read up on proportional fill.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

Thanks Gail.

One more request, could you please elaborate a bit against point no.1?

Thanks.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

What elaboration do you need?

If you want syntax, look up CREATE INDEX with the ON clause and the DROP_EXISTING clause.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Also, if the tables you are moving have BLOB datatypes, you will need to recreate the tables in the new filegroup in order to release the space from the first filegroup.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events