.png)
Drives used for SQL databases are running out of free space (SharePoint Foundation 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.
-
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.
-
Click OK.
Change History
| Date | Description |
|---|---|
| November 15, 2011 | Initial publication |
