Jul 12 2018 01:51 PM - edited Jul 12 2018 01:52 PM
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.
Jul 13 2018 05:17 AM
SolutionHere 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;
GO
In the article it suggest to set the backup mode to simple. Consult with your DBA before doing this.
Jul 13 2018 05:17 AM
SolutionHere 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;
GO
In the article it suggest to set the backup mode to simple. Consult with your DBA before doing this.