Drives used for SQL databases are running out of free space (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010, SharePoint Foundation 2010

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.

  1. Verify that the user account that is performing the following step is a member of the Administrators group on the local database server computer.

  2. Click Start, click All Programs, click Accessories, click System Tools, and then click Disk Defragmenter.

  3. Run the Disk Defragmenter tool to free disk space on the server computer.

  4. 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.

  1. Verify that the user account that is performing this procedure is a member of the Farm Administrators group.

  2. On the Central Administration Home page, click Monitoring.

  3. On the Monitoring page, in the Reporting section, click Configure diagnostic logging.

  4. On the Diagnostic Logging page, in the Trace Log section, in the Number of days to store log files box, type a smaller number.

  5. Click OK.