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

34 comments:

  1. 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
  2. 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
  3. Hello! I'm sorry, that is not the topic! I really like your forum! Thank you, I'm with you) Web 2.18

    ReplyDelete
  4. 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
  5. 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
  6. "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
  7. 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
  8. 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
  9. I for one use them only top notch components : you will see these people during: digital agency usa

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

    ReplyDelete
  11. 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
  12. 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
  13. Much thanks for sharing such a valuable article. Will spared and return to your site real estate

    ReplyDelete
  14. 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
  15. It is to some degree fabulous, but look at the guidance at this treat. Blog comment

    ReplyDelete
  16. 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
  17. 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
  18. Brilliant post.I need to thank you for this educational read, I truly value sharing this extraordinary post.Keep up your work 토토사이트 검증

    ReplyDelete
  19. 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
  20. 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
  21. 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
  22. I think about it is most required for making more on this get engaged Seo Package

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

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

    ReplyDelete
  25. 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
  26. 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
  27. Реклама и раскрутка сайта
    I'm going to read this. I'll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article

    ReplyDelete
  28. Portable applications keep your individuals or clients from downloading or making unapproved duplicates of your work.
    TutuApp web

    ReplyDelete
  29. If your looking for Online Illinois license plate sticker renewals then you have need to come to the right place.We offer the fastest Illinois license plate sticker renewals in the state. Addiction

    ReplyDelete
  30. Good day very cool website!! Man .. Excellent .. Superb .. I’ll bookmark your website and take the feeds additionally. I am glad to find a lot of useful information right here in the put up, we want to develop more strategies in this regard, thanks for sharing. . . . . . Digital Marketing Agency

    ReplyDelete
  31. Many small companies worry who hiring a completely independent cleaning company happens to be an expense construct y cannot afford to pay, however, with quite a few years of market place experience, DIALAMAID Cleaning could offer a office vacuuming package at a low cost price, leaving you with more time to take on growing and growing your internet business! cleaning services

    ReplyDelete
  32. Kamsoft technologies identify the digital gaps in your business industry and Digital Transformation Readiness With our Digital Transformation Company.

    ReplyDelete
  33. I am definitely enjoying your website. You definitely have some great insight and great stories. result totomacau

    ReplyDelete
  34. Nice to read your article! I am looking forward to sharing your adventures and experiences. F&I Ancillary Products

    ReplyDelete