Forum Discussion
Test SharePoint
Jul 12, 2018Brass Contributor
Cant increase storage for sharepoint server site collection and cant extract the ULS logs also
Cant increase storage for sharepoint server site collection and get this error message:
Sorry, something went wrong
Cannot complete this action.
Please try again.
Technical Details
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: ff247a9e-4238-a073-9236-3c4640e10d4f
Date and Time: 7/12/2018 4:16:17 PM
Same issue for all the site collections in all web applications.
tried running fiddler and got this : 401 at /admin/sitequota.aspx
I tried to configure the diagnostic logging to get the uls however got his error message:
Sorry, something went wrong
The transaction log for database 'AAISP_Config' is full due to 'LOG_BACKUP'.
Technical Details
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: 3e247a9e-b2e9-a073-9236-352a327593e2
Date and Time: 7/12/2018 4:03:09 PM
Found this article: http://manakhov.com/2016/01/ regarding the issue of uls logs error however I am not sure about this
Please any help is appreciated.
Here is a SQL Script that I run that will shrink your log file and bring things back to normal.
-- Set to SIMPLE mode
ALTER DATABASE [<database>] SET RECOVERY SIMPLE;
-- Shrink the db
DBCC SHRINKFILE ('database_log', 1);
-- Set back to FULL (optional depending on backup method used)
ALTER DATABASE [database] SET RECOVERY FULL;
GOIn the article it suggest to set the backup mode to simple. Consult with your DBA before doing this.
- spucelik
Microsoft
Here is a SQL Script that I run that will shrink your log file and bring things back to normal.
-- Set to SIMPLE mode
ALTER DATABASE [<database>] SET RECOVERY SIMPLE;
-- Shrink the db
DBCC SHRINKFILE ('database_log', 1);
-- Set back to FULL (optional depending on backup method used)
ALTER DATABASE [database] SET RECOVERY FULL;
GOIn the article it suggest to set the backup mode to simple. Consult with your DBA before doing this.