SharePoint database machine running out of disk space.

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 (1)

  1. Varun Shetty says:

    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.

Skip to main content