SQL Server Performance

database logs

Discussion in 'Getting Started' started by nirukonda, May 19, 2007.

  1. nirukonda New Member

    Hi folks,

    What is meant by database logs in sql server? How to view database logs for errors and issues in sql server?

    Thanks in advance

  2. MohammedU New Member

    For error you need check the sql server error log and sql agent log and appliation log but not the database log.

    Database logs are used for database transactions...
    You can't view them directly....
    There are no documented procedures but you can undocumented one or third party tools...


    All postings are provided “AS IS” with no warranties for accuracy.
  3. FrankKalis Moderator

    Check out the SQL Server Online Manual (aka BOL). It is very detailed in that respect.

    Frank Kalis
    Microsoft SQL Server MVP
  4. satya Moderator

    Why don't you refer through the forums before posting such a basic question?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page