DBA Posts - How to add data file to a filegroup?

You can add new data file to an existing filegroup or you can move data files from one filegroup to another.


1- Using T-SQL
 
ALTER DATABASE SQLAge
ADD FILE
(
NAME = SQLAge2,
FILENAME = 'D:\Datafiles\SQLAge\SQLAge_2.ndf',
SIZE = 10MB,
MAXSIZE = 100MB,
FILEGROWTH = 10MB
)
TO FILEGROUP SQLAgeFG1;
GO
 
2- Using Management Studio

                   a)      Right click on the database and go to properties

b)      Click on Files
c)      Click on Add
d)     Provide logical name of the file and click on dropdown manu of filegroups
e)      Click on the new filegroup that you have created






Fig 1 - How to add a data file in a filegroup

Fig 2 - How to add a data file in a filegroup

29 comments:

  1. Your content is nothing short of brilliant in many ways. I think this is engaging and eye-opening material. Thank you so much for caring about your content and your readers. agen bola online

    ReplyDelete
  2. This feature gives the light in which we can observe the reality. I love to reading an article that can make somebody believe. Thanks a lot for sharing a piece of wonderful information which I am looking for a longer period of time. movies1234

    ReplyDelete
  3. It is good that you always notice the positive image of these types of topics but on the other hand if you need related assistance. I really love this post and hope to see such informative news furthermore. Keep it up. SARMs for women

    ReplyDelete
  4. Hello! I'm sorry, that is not the topic! I really like your forum! Thank you, I'm with you) Web 2.18

    ReplyDelete
  5. Took me time to understand all of the comments, but I seriously enjoyed the write-up. It proved being really helpful to me and Im positive to all of the commenters right here! Its constantly nice when you can not only be informed, but also entertained! I am certain you had enjoyable writing this write-up. watch series

    ReplyDelete
  6. Your words on this post helps the audience to get a neat present volume of ideas. This is a cool great post on this perfect day. Thank YOU Slot

    ReplyDelete
  7. "Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog.

    " watch series

    ReplyDelete
  8. I am very delighted in for this blog. Its an instructive point. It help me particularly to tackle a few issues. Its chance are so awesome and working style so fast. The sims : Discover college is currently accessible worldwide on PC! Your apartment is prepared for you, dom't be late for your first day of class deocration

    ReplyDelete
  9. You really make it look so natural with your exhibition however I discover this issue to be really something which I figure I could never appreciate. It appears to be excessively confounded and amazingly wide for me. I'm searching forward for your next post, I'll attempt to get its hang! Slot gambling

    ReplyDelete
  10. I for one use them only top notch components : you will see these people during: digital agency usa

    ReplyDelete
  11. Brilliant post.I need to thank you for this educational read, I truly value sharing this extraordinary post.Keep up your work wedding

    ReplyDelete
  12. I am another client of this site so here I saw different articles and posts posted by this site,I inquisitive more enthusiasm for some of them trust you will give more data on this subjects in your next articles. how to create a cbd brand

    ReplyDelete
  13. Indeed, this made me think what different exercises are useful for those of us who end up out and about or have restricted hardware alternatives. their clothes for festivals

    ReplyDelete
  14. Much thanks for sharing such a valuable article. Will spared and return to your site real estate

    ReplyDelete
  15. I simply discovered this blog and have high trusts in it to proceed. Keep up the incredible work, its elusive great ones. I have added to my top picks. Much obliged to You. gifts

    ReplyDelete
  16. It is to some degree fabulous, but look at the guidance at this treat. Blog comment

    ReplyDelete
  17. I like your post. It is good to see you verbalize from the heart and clarity on this important subject can be easily observed... RRB Group D Admit Card

    ReplyDelete
  18. Nice to be visiting your blog again, it has been months for me. Well this article that i've been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share. Amy Coney Barrett

    ReplyDelete
  19. Brilliant post.I need to thank you for this educational read, I truly value sharing this extraordinary post.Keep up your work 토토사이트 검증

    ReplyDelete
  20. Hi! I'm grieved, that isn't the point! I truly like your gathering! Much obliged to you, I'm with you) judi slot online

    ReplyDelete
  21. I have read all the comments and suggestions posted by the visitors for this article are very fine,We will wait for your next article so only.Thanks! Substitute goods

    ReplyDelete
  22. Much obliged to you such a great amount for offering this Informative article to us. I truly love the method of your introduction. Kindly continue sharing more Blogcomment

    ReplyDelete
  23. I think about it is most required for making more on this get engaged Seo Package

    ReplyDelete
  24. That is really nice to hear. thank you for the update and good luck. Speedup Forex

    ReplyDelete
  25. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. situs judi slot online

    ReplyDelete
  26. I expounded on a comparative issue, I give you the connection to my site. IPTV

    ReplyDelete
  27. Great post, and great website. Thanks for the information! Sarkari Naukri

    ReplyDelete
  28. I basically need to reveal to you that I am new to weblog and certainly enjoyed this blog webpage. Likely I'm going to bookmark your blog . You totally have superb stories. Supports imparting to us your blog. grand junction real estate agent

    ReplyDelete
  29. 192.168.1.1 IP address is one of the most popular IP addresses for routers, and these are used to enter in web-interface which also known as admin panel, and there are a lot of different IP addresses except 192.168.l.l. Web-interface is one of the most important things that you should know about your router, where a lot of settings are responsible for your network’s security using web-interface with the IP and configure some settings. 192.168.1.1 Login It is to some degree fabulous, but look at the guidance at this treat.

    ReplyDelete