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

6 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