SQL server Logs

Posted on 2005-04-20
Last Modified: 2010-05-18
Hi All

I Need to know all the SQL logs including auditing the sql events, I want to check the SQL Logs so I can track any problmes in SQL, Also i want to know what is the maximum Databasesize in Ms SQL 2000.

Question by:ibmas4002
    LVL 95

    Accepted Solution

    Here's a comparison with MySQL 4.1 with info on SQL Server:

    Maximum Database size for Enterprise, Standard, Workgroup, and developer editions:
    1,048,516 terabytes

    (Scalability under "Product SKU Matrix")
    LVL 30

    Expert Comment

    There's the standard SQL logs, most easily found in Enterprise manager.

    Then you can also run a trace in SQL Profiler that will give you more event information than you could analyze in three lifetimes.

    Fire up SQL Profiler and have a look
    LVL 23

    Assisted Solution

    by:Racim BOUDJAKDJI
    The several logs you need to consider when using SQL Server:

    1) SQL Server Logs: you can find them under Enterprise Manager-->Management-->Error Logs  
    2) System and Application logs: you can find them under Control Panel-->Administrative tools-->Event Viewer
    3) Cluster Logs if your server is in a cluster

    Maximum database size depends on what version of SQL Server you got.  Data Center edition has a 32TB capacity.

    Hope this helped...
    LVL 23

    Expert Comment

    by:Racim BOUDJAKDJI
    Hi LearnedOne,

    With all respect to leew, believe I contributed to answer precisely to the asked question;  I do believe i deserve some points for that...

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now