CODEWITHSUNDEEP
sqlsql-server
veljasije
veljasije

Reputation: 7092

Limitations in number of files and filegroups in SQL Server 2012

I know that SQL Server database must have only one primary file ".mdf", but can consists few additional database files, named secondary files or ".ndf".

Is there any limitations in number of additional secondary files, or log files?

How many filegroups can one database have?

Upvotes: 1

Views: 4274

Answers (1)

Vishal Gajjar
Vishal Gajjar

Reputation: 1029

SQL Server supports 32,767 Files/FileGroups per database for both x86 and x64 installations.

You can find maximum capacity specifications here: http://msdn.microsoft.com/en-us/library/ms143432.aspx

Upvotes: 2

Related Questions