![]() ![]() Launch SQL Server Management Studio -> Connect to the SQL Server instance -> Expand Databases Right-click on DemoDatabase and click on Properties.įirst, we will change the MAXSIZE of data files. We can change the values by using any of the following methods.Ĭhange value using SQL Server Management Studio (SSMS)įirst, let us change the value using SQL Server management studio. In our case, we are going to set the value of the MAXSIZE parameter to UNLIMITED. To resolve this issue, we can increase the value of the MAXSIZE parameter or set the value to UNLIMITED. The maximum allowed size of the data and log file is set to 20MB. ![]() Run the following query to create the database.Īs you can in the above image, the value of the Autogrowth parameter for the data file is 12MB and the log file is 18MB. I have created a database named DemoDatabase, and the size of the database is 40MB. To understand the concept and error, we must create a demo setup with a specific configuration. When the database tries to grow beyond 10GB, the user will encounter the Primary filegroup is full error. The maximum allowed size of the database in SQL Server Express edition is 10GB. This error also occurs when we are using the SQL Server express edition. When we set the value of the MAXSIZE parameter limited to a specific value, we might encounter the Primary filegroup is full error. However, sometimes due to business requirements and hardware constraints, we are forced to keep the value of the MAXSIZE parameter to a specific value. When we create a new database, we set the value of the max size parameter to UNLIMITED most of the time. Also, they must do the capacity planning and space management according to the growth and utilization of the database. The database administrators must keep track of the database growth. In this article, we are going to understand SQL Server error: The Primary filegroup is full and how we can fix this error.
0 Comments
Leave a Reply. |