Hello all,
Somehow my SQL server logs under Management in SQL server enterprise server is too big, it takes long time to view all logs. My current log is 8228442 bytes. Are there anyways I can delete the log? Please so me how to.

Thanks for all HELPS!

Right-click on the database, click on "All Tasks ->" then "Shrink Database...". Take it from there! You can also click on the "Files..." button to get more specific settings.


Peter

Thanks, but the logs are not pointing to a specific DB so how do I know which one to shrink?

I think there may some confusion here between the database transaction logs, and the SQL Server error logs.

You can shrink the transaction logs, but as far as I know you can only limit the number of error logs maintained by the system. A new error log is created every time SQL Server starts, and the logs are eventually 'recycled'.

You might want to look at the reasons why your error logs are so big - if they are big it either means there are lots of errors in them, or you haven't restarted SQL Server in a long time.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com