How to Archive current sql server logs

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

How to archive current sql server logs

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.
New SQL Server DBA
Hi
EXEC sp_cycle_errorlog
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
> 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.
> --
> New SQL Server DBA
|||THANKS!
New SQL Server DBA
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> EXEC sp_cycle_errorlog
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
>
>

How to archive current sql server logs

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.
--
New SQL Server DBAHi
EXEC sp_cycle_errorlog
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
> 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.
> --
> New SQL Server DBA|||THANKS!
--
New SQL Server DBA
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> EXEC sp_cycle_errorlog
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
> > 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.
> > --
> > New SQL Server DBA
>
>

How to archive current sql server logs

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 s
o
long to view the current file?
Thanks in advance.
--
New SQL Server DBAHi
EXEC sp_cycle_errorlog
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
> 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.
> --
> New SQL Server DBA|||THANKS!
--
New SQL Server DBA
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> EXEC sp_cycle_errorlog
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
>
>