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 communityCurrently I'm facing an issue of insufficient size of my SharePoint database, and I need to edit the:
Where do I go to change these settings?
Two things,
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 :