Hi Guru's,
It takes me a long time to view in EM under Mangement/SQL Server Logs/current file. Is there a way I can shorten that file so it won't take so long to view the current file?
Thanks in advance. :eek:DBCC ERRORLOG will rotate the logs. I set up a job to rotate mine once per month.|||DBCC ERRORLOG will rotate the logs. I set up a job to rotate mine once per month.
sp_cycle_errorlog will achieve the same effect. You might also consider taking a look at sp_delete_ backuphistory.
Regards,
hmscott
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment