Drives used for SQL databases are running out of free space (SharePoint 2013)
Published: July 16, 2012
Summary: Learn how to resolve the SharePoint Health Analyzer rule "Drives used for SQL databases are running out of free space."
Applies to: SharePoint Foundation 2013 | SharePoint Server 2013
Rule Name: Drives used for SQL databases are running out of free space.
Summary: The databases have one or more files that exceed the available free disk drive space. If this happens, operations will fail. A disk drive should have enough free space to allow the largest database file to automatically grow to twice its size.
Cause: The databases have large files that may exceed the available free space.
Resolution: Free disk space on the database server computer.
Verify that the user account that is performing the following step is a member of the Administrators group on the local database server computer.
Click Start, click All Programs, click Accessories, click System Tools, and then click Disk Defragmenter.
Run the Disk Defragmenter tool to free disk space on the server computer.
If the event persists, move some large files to another disk drive to free up space.
Resolution: Decrease the number of days to store log files.
Verify that the user account that is performing this procedure is a member of the Farm Administrators group.
On the Central Administration Home page, click Monitoring.
On the Monitoring page, in the Reporting section, click Configure diagnostic logging.
On the Diagnostic Logging page, in the Trace Log section, in the Number of days to store log files box, type a smaller number.