SOLVED

Cant increase storage for sharepoint server site collection and cant extract the ULS logs also

Brass Contributor

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.

1 Reply
best response confirmed by Test SharePoint (Brass Contributor)
Solution

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;


GO

 

In the article it suggest to set the backup mode to simple.  Consult with your DBA before doing this.

1 best response

Accepted Solutions
best response confirmed by Test SharePoint (Brass Contributor)
Solution

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;


GO

 

In the article it suggest to set the backup mode to simple.  Consult with your DBA before doing this.

View solution in original post