location for the error log in MS SQL Server 2000

  • nivedita.kathal

    Right there with Babe

    Points: 742


    I am working in MS SQL server 2000, I run the DBCC command in the server first time. Can any one please suggest me where the error log can be generated(except the default location i.e. C:\Program Files\Microsoft SQL Server\instance of SQL\MSSQL\LOG......) .

  • NitinPatel31

    Hall of Fame

    Points: 3661

    There is no other place then default log location.


  • nivedita.kathal

    Right there with Babe

    Points: 742

    But while searching for the LOG directory in the C:\Program Files\Microsoft SQL Server\MSSQL(where the error logs gets save) i didn't got any LOG folder.

    Since the server is production database server ,there may be a possibility that the errorlog files gets stored in some other drive.

    So could you please suggest me what is the way to get the path for the error log.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 717790

    The startup parameter (-e) for the service determines the log location.

    Please post in the correct forum. Not just anywhere.

    Moved to the 2000 forum.

  • gary.proctor

    Mr or Mrs. 500

    Points: 580


    In SS05 you can get SSIS to log to a table instead of a text file if that would be easier. It logs information to a NON-sys table in the database. The table is automatically named dbo.sysdtslog90. Would that be easier to work with?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply