Currently I'm facing an issue of insufficient size of my SharePoint database, and I need to edit the:
- Autogrowth of the db
- Maximum size file limit
Where do I go to change these settings?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
For the Max Size check this
USE [master] GO ALTER DATABASE [myDatabaseName] MODIFY FILE ( NAME = N'myDatafileNAme', SIZE = 10240KB ) GO
For AutoGrowth Please check this:
USE [master] GO ALTER DATABASE [MyTechMantra] MODIFY FILE ( NAME = N'MyTechMantra', FILEGROWTH = 512MB ) GO ALTER DATABASE [MyTechMantra] MODIFY FILE (NAME = N'MyTechMantra_log', FILEGROWTH = 256MB ) GO
Please open Microsoft SQL Server Management Studio and find the database which you used .
Right click this DB and select properties , select files , modify the value ”initial size” to expected size and click ok.
After process finish , please restart SQL server service :
Open SQL Server Configuration Manager , restart SQL server service :