SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Add new ndf in diff drive
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

chloelee
Starting Member

Malaysia
6 Posts

Posted - 07/18/2013 :  05:06:21  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 07/18/2013 :  05:20:47  Show Profile  Reply with Quote
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
Go to Top of Page

chloelee
Starting Member

Malaysia
6 Posts

Posted - 07/18/2013 :  06:16:06  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 07/18/2013 :  06:18:11  Show Profile  Reply with Quote
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
Go to Top of Page

chloelee
Starting Member

Malaysia
6 Posts

Posted - 07/18/2013 :  07:02:44  Show Profile  Reply with Quote
yes i did, but i can't find the solution. I will read further... thanks for providing the page.

Best wishes,
Chloe
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 07/18/2013 :  07:08:06  Show Profile  Reply with Quote
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
Go to Top of Page

chloelee
Starting Member

Malaysia
6 Posts

Posted - 07/18/2013 :  11:18:52  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 07/18/2013 :  11:25:24  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000