?
Solved

ERRORLOG file too big

Posted on 2014-04-15
1
Medium Priority
?
282 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 2000 total points
ID: 40001979
EXEC sp_cycle_errorlog

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

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

752 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