Moving Indexes to new drive

Hi All,

I want to move all indexes into new separate drive for this I need to create new .ndf file in particular drive.

Mirroring has configured for the DB but the principal and mirror servers do not have same drives.
In principal I want to move indexes to new I:/ drive and the I:/ derive is not present in mirror server Please suggest.


September 1st, 2015 10:58pm

As you probably know moving a CI all the data will be moved  to the new drive 

Read this thread

 http://stackoverflow.com/questions/4237238/moving-all-non-clustered-indexes-to-another-filegroup-in-sql-server

Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 11:50pm

As you probably know moving a CI all the data will be moved  to the new drive 

Read this thread

 http://stackoverflow.com/questions/4237238/moving-all-non-clustered-indexes-to-another-filegroup-in-sql-

September 2nd, 2015 1:23am
You can deploy database mirroring with different drive structure, but if you add a file to the Principal, the DDL commands get applied across the Mirror, then your database probably goes into a suspended mode status
Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2015 3:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics