4,590 questions
Please steps provided in this article. The article provides screenshots and step-by-step instructions for troubleshooting this issue.
Drives used for SQL databases are running out of free space.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 92%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET0%3C/text%3E%3C/svg%3E)
Tevon2.0
1,106
Reputation points
Greetings I currently have two notifications on my sharepoint health analyzer but I am unsure of how to go about taking action in rectifying them. Could someone explain the steps clearly as I have never had to clear space on my drives before. Also please inform me of the best method of preventing this storage limitation moving forward. Screenshots appreciated if possible! Thanks!
- Drives used for SQL databases are running out of free space.
The following databases have one or more files that may exceed the available free drive space. If this happens, operations will start to fail. WSS_Empctr-Content on SRV-SHAREPOINT, WSS_Empctr-Content on SRV-SHAREPOINT, User Profile Service Application_SyncDB_666b679179f44224a022527c7b0ce14e on SRV-SHAREPOINT, User Profile Service Application_SyncDB_666b679179f44224a022527c7b0ce14e on SRV-SHAREPOINT, WSS_Content on SRV-SHAREPOINT, WSS_Content on SRV-SHAREPOINT, Search_Service_Application_CrawlStoreDB_aa07d4115539460ab460d8353e0729e8 on SRV-SHAREPOINT, Search_Service_Application_CrawlStoreDB_aa07d4115539460ab460d8353e0729e8 on SRV-SHAREPOINT, WSS_Content_LGPORTAL on SRV-SHAREPOINT, WSS_Content_LGPORTAL on SRV-SHAREPOINT, Managed Metadata Service_80c836382a3348a3aa3dd05090c4c3d8 on SRV-SHAREPOINT, Managed Metadata Service_80c836382a3348a3aa3dd05090c4c3d8 on SRV-SHAREPOINT, Search_Service_Application_DB_731dc800237a4517ae41684ca65c2d81 on SRV-SHAREPOINT, Search_Service_Application_DB_731dc800237a4517ae41684ca65c2d81 on SRV-SHAREPOINT, Search_Service_Application_LinksStoreDB_cb655a0041964d30a5c1d48ffe11f113 on SRV-SHAREPOINT, Search_Service_Application_LinksStoreDB_cb655a0041964d30a5c1d48ffe11f113 on SRV-SHAREPOINT, AppMng_Service_DB_021a5987e4e34599b16790468040b25a on SRV-SHAREPOINT, AppMng_Service_DB_021a5987e4e34599b16790468040b25a on SRV-SHAREPOINT, SharePoint_Config on SRV-SHAREPOINT, SharePoint_Config on SRV-SHAREPOINT, SharePoint_AdminContent_1b64db8c-0fe9-4eda-9905-895401ed9963 on SRV-SHAREPOINT, SharePoint_AdminContent_1b64db8c-0fe9-4eda-9905-895401ed9963 on SRV-SHAREPOINT, User Profile Service Application_SocialDB_09141a91092345db824446da3f6a21ca on SRV-SHAREPOINT, User Profile Service Application_SocialDB_09141a91092345db824446da3f6a21ca on SRV-SHAREPOINT, WordAutomationServices_467be4fee9fa44649f1b1d72d7d150e6 on SRV-SHAREPOINT, WordAutomationServices_467be4fee9fa44649f1b1d72d7d150e6 on SRV-SHAREPOINT, Secure_Store_Service_DB_ffcce9743ddd41cd9144461ac49dedcf on SRV-SHAREPOINT, Secure_Store_Service_DB_ffcce9743ddd41cd9144461ac49dedcf on SRV-SHAREPOINT, TranslationService_2d083def17af48a6b4ef2b047a288e18 on SRV-SHAREPOINT, TranslationService_2d083def17af48a6b4ef2b047a288e18 on SRV-SHAREPOINT, User Profile Service Application_ProfileDB_fbb6d2670cb64b0ab63732d221fa4729 on SRV-SHAREPOINT, User Profile Service Application_ProfileDB_fbb6d2670cb64b0ab63732d221fa4729 on SRV-SHAREPOINT, WSS_UsageApplication on SRV-SHAREPOINT, WSS_UsageApplication on SRV-SHAREPOINT, Bdc_Service_DB_24bf370e537e4f9f82281b39b7398cd2 on SRV-SHAREPOINT, Bdc_Service_DB_24bf370e537e4f9f82281b39b7398cd2 on SRV-SHAREPOINT, Search_Service_Application_AnalyticsReportingStoreDB_def663faf48f4b839924ef6668df0762 on SRV-SHAREPOINT, Search_Service_Application_AnalyticsReportingStoreDB_def663faf48f4b839924ef6668df0762 on SRV-SHAREPOINT, StateService_2783f32f801442f587f21b036f298036 on SRV-SHAREPOINT, StateService_2783f32f801442f587f21b036f298036 on SRV-SHAREPOINT
Examine the drives containing the specified databases' log and data files. Free space on these drives or move the database files to another drive. A drive should have enough free space for the largest database file on it to autogrow twice.
*Drives are running out of free space.
Available drive space is less than 4 GB. This is dangerous because it does not provide enough room for a full memory dump with continued operation. It also could cause problems with the Virtual Memory swap file: (SRV-SHAREPOINT - C:).
Examine the failing servers and delete old logs or free space on the drives.
Microsoft 365 and Office SharePoint Server For business
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,326 questions
SQL Server Other
14,494 questions
2 answers
Sort by: Most helpful
-
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator2023-01-03T15:39:59.347+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jingyang Li 5,896 Reputation points Volunteer Moderator2023-01-03T16:07:04.583+00:00 Do you manage your sharepoint databases by yourself? These SQL Server databases need to be maintained with proper backups. The log backup will release the log file space in most cases.
If you don't have a backup process for data and log files of your database, you must create one with built-in tool (maintenance plan) , third part scripts, or your own scripts and run these scripts regularly to keep your database log file size in control.-
Tevon2.0 1,106 Reputation points
2023-01-03T16:32:37.443+00:00 I have newly been promoted into this new role so I haven't had to maintain a SQL database before. I am trying to learn the best method of how to perform and maintain backups. It doesn't appear that they currently have a system in place for back up processes. I'm working with SharePoint server at a location with everything on prim.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2023-01-03T22:13:24.59+00:00 The log backup will release the log file space in most cases.
To clarify: the log backup will release space inside the file, but the size in the file system will not change, unless you explicitly shrink.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator2023-01-04T00:06:17.677+00:00 Sharepoint has it own job scheduler. it should be doing backups. but you need a system to move the backup to offsite storage. once the backup file is moved, it can be deleted.
https://learn.microsoft.com/en-us/sharepoint/administration/best-practices-for-backup-and-restore
it is really import to backup the configuration databases.
Sharepoint is also warning that the system disk is out of space and does not have enough space for a crash dump. The system may have been configured this way, of the temp folder is too big. You might need to delete o/s sp updates, which are only kept to allow reverts.
note: unless you are purging content, the databases only grow.
-
Yi Lu_MSFT 17,611 Reputation points2023-01-09T09:48:38.987+00:00 Hi @Tevon2.0
Do you have any further questions about this thread? If you have any questions or progress, you can contact me in time.
Sign in to comment -