SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-215098%22%20slang%3D%22en-US%22%3ECant%20increase%20storage%20for%20sharepoint%20server%20site%20collection%20and%20cant%20extract%20the%20ULS%20logs%20also%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215098%22%20slang%3D%22en-US%22%3E%3CP%3ECant%20increase%20storage%20for%20sharepoint%20server%20site%20collection%20and%20get%20this%20error%20message%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20something%20went%20wrong%3CBR%20%2F%3ECannot%20complete%20this%20action.%3C%2FP%3E%3CP%3EPlease%20try%20again.%3CBR%20%2F%3ETechnical%20Details%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ETroubleshoot%20issues%20with%20Microsoft%20SharePoint%20Foundation.%3C%2FP%3E%3CP%3ECorrelation%20ID%3A%20ff247a9e-4238-a073-9236-3c4640e10d4f%3C%2FP%3E%3CP%3EDate%20and%20Time%3A%207%2F12%2F2018%204%3A16%3A17%20PM%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20issue%20for%20all%20the%20site%20collections%20in%20all%20web%20applications.%3C%2FP%3E%3CP%3Etried%20running%20fiddler%20and%20got%20this%20%3A%20401%20at%20%2Fadmin%2Fsitequota.aspx%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20configure%20the%20diagnostic%20logging%20to%20get%20the%20uls%20however%20got%20his%20error%20message%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ESorry%2C%20something%20went%20wrong%3CBR%20%2F%3EThe%20transaction%20log%20for%20database%20'AAISP_Config'%20is%20full%20due%20to%20'LOG_BACKUP'.%3CBR%20%2F%3ETechnical%20Details%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ETroubleshoot%20issues%20with%20Microsoft%20SharePoint%20Foundation.%3C%2FP%3E%3CP%3ECorrelation%20ID%3A%203e247a9e-b2e9-a073-9236-352a327593e2%3C%2FP%3E%3CP%3EDate%20and%20Time%3A%207%2F12%2F2018%204%3A03%3A09%20PM%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFound%20this%20article%3A%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Fmanakhov.com%2F2016%2F01%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fmanakhov.com%2F2016%2F01%2F%3C%2FA%3E%20regarding%20the%20issue%20of%20uls%20logs%20error%20however%20I%20am%20not%20sure%20about%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20any%20help%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-215098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EStorage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215330%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20increase%20storage%20for%20sharepoint%20server%20site%20collection%20and%20cant%20extract%20the%20ULS%20logs%20also%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215330%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20a%20SQL%20Script%20that%20I%20run%20that%20will%20shrink%20your%20log%20file%20and%20bring%20things%20back%20to%20normal.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E--%20Set%20to%20SIMPLE%20mode%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EALTER%20DATABASE%20%5B%3CDATABASE%3E%5D%20SET%20RECOVERY%20SIMPLE%3B%3C%2FDATABASE%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E--%20Shrink%20the%20db%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EDBCC%20SHRINKFILE%20('database_log'%2C%201)%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E--%20Set%20back%20to%20FULL%20(optional%20depending%20on%20backup%20method%20used)%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EALTER%20DATABASE%20%5Bdatabase%5D%20SET%20RECOVERY%20FULL%3B%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CSPAN%3E%20GO%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EIn%20the%20article%20it%20suggest%20to%20set%20the%20backup%20mode%20to%20simple.%26nbsp%3B%20Consult%20with%20your%20DBA%20before%20doing%20this.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Test SharePoint
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
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.

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies