can we change the file size that c2 creates a new trc file at ?

From: Simo Sentissi (msentissi_at_rightnow.com)
Date: 06/22/05

  • Next message: Hari Prasad: "Re: can we change the file size that c2 creates a new trc file at ?" 
    Date: Wed, 22 Jun 2005 15:51:01 -0600

    hello there

    I want to know if I can have sql server C2 login log to a file till it
    reaches 10 megs and switch to another one.
    the reason is that I want to ship the logs to a log aggregation software
    every hour or so ?

    any ideas ?

  • Next message: Hari Prasad: "Re: can we change the file size that c2 creates a new trc file at ?"

    Relevant Pages

    • Re: Configuring SQL 2005 Memory
      ... I'm also trying to limit allocation of ram to SQL. ... I guess that I'm struggling with whether SQL (without this switch) limits itself to less than 2GB in aggregate of ram or does each instance stand on its own. ... Exchange isn't the only major application on SBS -- SQL Server is also running and my question was related to SQL and the 3/GB switch. ... The Address Windowing Extensions API that Microsoft Windows exposes allows application developers to access more than 2 GB of memory on 32-bit systems. ...
      (microsoft.public.windows.server.sbs)
    • Re: Configuring SQL 2005 Memory
      ... I guess that I'm struggling with whether SQL (without this switch) limits itself to less than 2GB in aggregate of ram or does each instance stand on its own. ... Exchange isn't the only major application on SBS -- SQL Server is also running and my question was related to SQL and the 3/GB switch. ... The Address Windowing Extensions API that Microsoft Windows exposes allows application developers to access more than 2 GB of memory on 32-bit systems. ...
      (microsoft.public.windows.server.sbs)
    • Re: Configuring SQL 2005 Memory
      ... Exchange isn't the only major application on SBS -- SQL Server is also running and my question was related to SQL and the 3/GB switch. ... The Address Windowing Extensions API that Microsoft Windows exposes allows application developers to access more than 2 GB of memory on 32-bit systems. ...
      (microsoft.public.windows.server.sbs)
    • Re: Full Text - Index Population - HDD Access
      ... Have you implemented the /3GB switch in the OS boot.ini? ... 2GB is set aside for apps and 2GB for OS. ... This probably explains why SQL Server is only ... using 1.7GB RAM. ...
      (microsoft.public.sqlserver.fulltext)
    • Re: Question RE /PAE In Active-Active Cluster
      ... different NT kernel which contains the code to address RAM> 4GB. ... The AWE setting in SQL Server works with the /PAE switch. ... address by setting the max server memory config option. ...
      (microsoft.public.sqlserver.clustering)