<div>
<div class="content wysiwyg-content">
The file @<br />
&nbsp;D:\MSSQL10.MSSQLSERVER\MSS<wbr />QL\Log\ERR<wbr />ORLOG<br />
&nbsp;file is 52 GB.<br />
&nbsp;<br />
but the error log files for each reboot- they are small.<br />
&nbsp;D:\MSSQL10.MSSQLSERVER\MSS<wbr />QL\Log\ERR<wbr />ORLOG.1...<wbr /> D:\MSSQL10.MSSQLSERVER\MSS<wbr />QL\Log\ERR<wbr />ORLOG.6 are small (only few MBs or even less)<br />
<br />
what is the big file.. and how can i reduce its space?<br />
<br />
thanks.
</div>
</div>


The file @
 D:\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
 file is 52 GB.
 
but the error log files for each reboot- they are small.
 D:\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG.1... D:\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG.6 are small (only few MBs or even less)

what is the big file.. and how can i reduce its space?

thanks.

ERRORLOG file too big

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.