Home Forums SQL Server 2016 SQL Server 2016 - Administration Running out of space on Server OS drive, where SQL Server app located, what to clear out? RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

  • No, it does not simply truncate the current error log, it closes the current error log and cycles the error logs in a similar fashion to a server restart, see these two articles for details:
    https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-cycle-errorlog-transact-sql and
    https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-cycle-agent-errorlog-transact-sql.

    ...