Add filegroup in Azure Sql?

Question

Add filegroup in Azure Sql?

AIRin 21

I would like to add filegroup in Azure Sql, and I found out that there is no filegroup available to be added. please assist me on this issue. And if there is any other way to add file group without using script.

Accepted answer

0 additional answers

Your answer

Answer 1

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

Hi, @AIRing-7416 Welcome to the Microsoft Q&A Platform, and thanks for your query.
As we understand you want to know if you can add filegroup in Azure sql.
Unfortunately, you don't have control over filegroups I mean you can't add or create new filegroups, Azure will add the file groups ..If we increase the storage space. Azure will add the file groups based on the requirement.

Please let me know if you need any additional information.

Regards
Geetha

AIRin 21 Reputation points

2022-06-21T08:07:36.083+00:00

Hi Geetha, thanks for the answer. In the way, may I know how should I check the current filegroup using?
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-06-21T08:38:53.013+00:00

Thanks, @AIRing-7416 you can try TSQL command.
SELECT distinct a.fileid, sf.groupname as Filegroup,a.name,
case maxsize when 268435456 then -1 else maxsize*8 /1024 end as MaxSize ,
CONVERT(Decimal(15,2),ROUND(a.Size/128.000,2)) [Currently Allocated Space (MB)],
CONVERT(Decimal(15,2),ROUND(FILEPROPERTY(a.Name,'SpaceUsed')/128.000,2)) AS [Space Used (MB)],
CONVERT(Decimal(15,2),ROUND((a.Size-FILEPROPERTY(a.Name,'SpaceUsed'))/128.000,2)) AS [Available Space (MB)],
growth *8 /1024 as [Growth (MB)],a.filename
FROM sys.sysfiles AS a with (nolock)
left join sysfilegroups sf with (nolock) on a.groupid = sf.groupid
order by 2 asc

Regards
Geetha
AIRin 21 Reputation points

2022-06-21T08:51:45.913+00:00

@GeethaThatipatri-MSFT , Thanks a lot.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-06-21T08:57:51.927+00:00

@AIRin Thank you for visiting the Microsoft QA forums! Have a great day!

Share via

Add filegroup in Azure Sql?

0 additional answers

Your answer