Forum Discussion

Test SharePoint's avatar
Test SharePoint
Brass Contributor
Jul 12, 2018
Solved

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 Troubles...
  • spucelik's avatar
    Jul 13, 2018

    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.

Resources