goldwhispers
Programmer
does anyone know how long they keep for and where the properties are set for that, i can't see to get an answer and if i looked at the archived logs and compare sizes and dates, tehere doesn't seem to be a pattern
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sql logs
- Thread starter goldwhispers
- Start date
- Status
Everytime you stop and start the SQL Server services, it closes out the current log and starts a new one. That can cause the logs to have different sizes. The stored procedure, sp_cycle_errorlog, also can be used to stop the current log and open a new one.
Refer to the BOL, use the index tab and enter Error Log for more information.
-SQLBill
Posting advice: FAQ481-4875
Refer to the BOL, use the index tab and enter Error Log for more information.
-SQLBill
Posting advice: FAQ481-4875
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
