Solved

ERRORLOG file too big

Posted on 2014-04-15
1
273 Views
Last Modified: 2014-04-15
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.
0
Comment
Question by:25112
1 Comment
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 500 total points
ID: 40001979
EXEC sp_cycle_errorlog

will force SQL to archive that log and start a new one.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now