Add new ndf in diff drive - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Add new ndf in diff drive

Author

Topic

chloelee
Starting Member

6 Posts

Posted - 2013-07-18 : 05:06:21

hi experts,

I have a databse with size 400GB only in mdf. Is it possible to split this 400GB to mdf in D:\, and create another ndf in E:\? how can i perform this exercise?

Appreciate your advice.

Thanks.

Best wishes,
Chloe

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-18 : 05:20:47

you need to create file groups for database and map associated files to E:\. Then you need to move some of the objects to newly created filegroups in E:\. you can do this by recreating clustered keys in the new file group

see

http://www.mssqltips.com/sqlservertip/2442/move-data-between-sql-server-database-filegroups/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

chloelee
Starting Member

6 Posts

Posted - 2013-07-18 : 06:16:06

Hi Visakh,

How to recreating clustered keys in the new file group? is it possibl you can elaborate further? Sorry that i'm not good in this.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-18 : 06:18:11

quote:
Originally posted by chloelee

Hi Visakh,

How to recreating clustered keys in the new file group? is it possibl you can elaborate further? Sorry that i'm not good in this.

Did you check the posted link at all?
It has different methods of doing it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

chloelee
Starting Member

6 Posts

Posted - 2013-07-18 : 07:02:44

yes i did, but i can't find the solution. I will read further... thanks for providing the page.

Best wishes,
Chloe

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-18 : 07:08:06

quote:
Originally posted by chloelee

yes i did, but i can't find the solution. I will read further... thanks for providing the page.

Best wishes,
Chloe

It clearly shows screenshots to change filegroup from GUI as well as using T-SQL query

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

chloelee
Starting Member

6 Posts

Posted - 2013-07-18 : 11:18:52

oh... so sorry about that. I had too many browsers just now and overlooked the link of yours; the link is clearly showing the method. Thank you very much and truly appreciate your help.

Best wishes,
Chloe

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-18 : 11:25:24

quote:
Originally posted by chloelee

oh... so sorry about that. I had too many browsers just now and overlooked the link of yours; the link is clearly showing the method. Thank you very much and truly appreciate your help.

Best wishes,
Chloe

No problem

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources