August 1, 2008 at 5:13 am
Hi,
I have a database with one filegroup primary which has .mdf file and two .ndf files.How to create table on a particular .ndf file?Im using sql server 2005.
Thanks in advance.
August 1, 2008 at 5:17 am
Create a new filegroup pointing to a new ndf datafile then create your table pointing to the newly created filegroup.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 1, 2008 at 5:24 am
Thank you paul for you immediate reply.
But it is a production server i cant add any filegroup now.
Without adding a filegroup can i do that?
August 1, 2008 at 5:28 am
No, you can't.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply