Re: Size of SQL server logs

From: Greg Linwood (g_linwoodQhotmail.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 23:27:21 +1100

You can do this in the SQL Server Enterprise Manager - right click the
database, select properties & you'll find it under the Log File tab.

Regards,
Greg Linwood
SQL Server MVP

"Tine Hansen" <TineHansen@discussions.microsoft.com> wrote in message
news:03E76FA3-611D-4A1B-95AA-BD281BF9E384@microsoft.com...
> Hi,
> Sometimes my Sql server logs expands very munch and eat up all my disk
> space
> on the c drive. Where or how can I set the max size on the server logs ?
>
> I'm using sql server 2000 and sp3
>
> Thanks

Relevant Pages

  • Re: Error re-installing SQL Server 2005
    ... i actually was able to export the reg entries from my ... SQL Server Setup could not connect to the database service for server ... Refer to server error logs and setup logs for ... For details on how to view setup logs, ...
    (microsoft.public.sqlserver.setup)
  • Re: Cluster will not fail over.
    ... Could not recover the master database! ... If you intend to stay on SP3 (for SQL Server), you should at least apply the ... >> From SQL server logs ...
    (microsoft.public.sqlserver.clustering)
  • Re: Error re-installing SQL Server 2005
    ... SQL Server Setup could not connect to the database service for server ... Refer to server error logs and setup logs for more ... For details on how to view setup logs, ... Kevin Struckhoff ...
    (microsoft.public.sqlserver.setup)
  • Re: host_name
    ... When the user logs in, ... >> of a client from sql server. ... >> For security reasons every user of our database system logs into our ... >> This can't be changed as we are limited to 3 database users. ...
    (comp.databases.ms-sqlserver)
  • Re: Error re-installing SQL Server 2005
    ... Kevin Struckhoff ... > decided to try out sql server 2008 rc0. ... Refer to server error logs and setup logs for ... For details on how to view setup logs, ...
    (microsoft.public.sqlserver.setup)