|
Home > Archive > MS SQL Server > October 2006 > Logging Autogrow operations in errorlog
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Logging Autogrow operations in errorlog
|
|
| Himanshu 2006-10-24, 6:30 pm |
| When database files are set to autogrow, I've noticed that the SQL Server
errorlog does not log any information regarding autogrow operations.
Is there any way to configure SQL Server to log such operations?
Thanks.
| |
| Sue Hoegemeier 2006-10-24, 6:31 pm |
| Can't think of a trace flag to log this but you can capture
the information in a trace - capture the event log file
autogrow.
-Sue
On Thu, 21 Sep 2006 11:51:01 -0700, Himanshu
< Himanshu@discussions
.microsoft.com> wrote:
>When database files are set to autogrow, I've noticed that the SQL Server
>errorlog does not log any information regarding autogrow operations.
>
>Is there any way to configure SQL Server to log such operations?
>
>Thanks.
| |
| Kalen Delaney 2006-10-24, 6:31 pm |
| Since it's not technically an error when autogrow occurs, there is nothing
written to the errorlog. However, there is a trace event that can be written
to a trace file when autogrow occurs.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Himanshu" < Himanshu@discussions
.microsoft.com> wrote in message
news:AEAD93BF-583F-4DB9-BBF9- 5640DED39719@microso
ft.com...
> When database files are set to autogrow, I've noticed that the SQL Server
> errorlog does not log any information regarding autogrow operations.
>
> Is there any way to configure SQL Server to log such operations?
>
> Thanks.
|
|
|
|
|