Export (0) Print
Expand All
Expand Minimize

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

SharePoint 2010

Published: November 15, 2011

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft