SharePoint database machine running out of disk space.

  • Article

This is a common problem. The first thing you might want to inspect is the database size.

Navigate to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA

Check the size of SharePoint_Config database. If this database is taking more disk space you are at the right page.

Run the following commands and you should be good.

alter database sharepoint_config set recovery simple
dbcc shrinkfile(sharepoint_config_log,50)
alter database sharepoint_config set recovery full

Comments

  • Anonymous
    January 07, 2016
    DBCC SHRINKDATABASE(N'WSS_UsageApplication', 10 ) The above command should do the trick. Where 10 being the % of free space available for that particular database shrink.