Prev: linked server to foxpro, how??
Next: Auto stats interfere with ALTER COLUMN...
From: Uday on 12 Aug 2008 17:04
The default trace file that is located in the following location:

~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_1.trc
~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_2.trc
~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_3.trc
....
....
....

How do I configure to increase the file size and the max. number of files
for rollover? The default size is suppossed to be 32MB with retention period
of 14 days
before deletion. But in my servers case, the size is defaulting to 512KB....
thats just too small.

I looked at sys.configurations, but did not see any option for that.

Any help would be great...

'thanks,
_Uday
From: Tibor Karaszi on 13 Aug 2008 02:26
> The default size is suppossed to be 32MB with retention period
> of 14 days

Where did you find that information? AFAIK, max size is (supposed to be) 20 MB with no retention
days - rather max number of files is 5 (then oldest file is deleted). Note that if you restart SQL
server, then a new file is created - that is just how tracing work. Can you show the result from
below query:

SELECT id, path, max_size, max_files, is_rollover
FROM sys.traces
WHERE id = 1

max size should be 20 and max files should be 5. There are no means thos change these values
(AFAIK).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Uday" <Uday(a)discussions.microsoft.com> wrote in message
news:EE7A30F3-FEDB-45C0-994F-34F3561BC933(a)microsoft.com...
> The default trace file that is located in the following location:
>
> ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_1.trc
> ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_2.trc
> ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_3.trc
> ....
> ....
> ....
>
> How do I configure to increase the file size and the max. number of files
> for rollover? The default size is suppossed to be 32MB with retention period
> of 14 days
> before deletion. But in my servers case, the size is defaulting to 512KB....
> thats just too small.
>
> I looked at sys.configurations, but did not see any option for that.
>
> Any help would be great...
>
> 'thanks,
> _Uday


From: Uday on 13 Aug 2008 09:54
Thanks a lot for your help Tibor. Like you said.... it is set to 20 MB. But
the files on my server are not 20 MB. As of today I have 512 KB, 1 MB and 5
MB files....

1 E:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\log_9.trc 20 5 1

Do these log all the events?


From: Tibor Karaszi on 14 Aug 2008 03:41
I would start by checking if that corresponds to restarts of SQL server. If not, then I would open a
case with MS Support since you would have found a bug in the product (as far as I can understand).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Uday" <Uday(a)discussions.microsoft.com> wrote in message
news:C65E362C-E8CC-4FC7-9708-4AA8D82D7CC4(a)microsoft.com...
> Thanks a lot for your help Tibor. Like you said.... it is set to 20 MB. But
> the files on my server are not 20 MB. As of today I have 512 KB, 1 MB and 5
> MB files....
>
> 1 E:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\log_9.trc 20 5 1
>
> Do these log all the events?
>
>


 | 
Pages: 1
Prev: linked server to foxpro, how??
Next: Auto stats interfere with ALTER COLUMN...