SQL Error Log is not logging events properly

From: Andy S. (andymcdba1_at_noreply.yahoo.com)
Date: 11/11/05

  • Next message: Andrew J. Kelly: "Re: Scripting Permission" 
    Date: Fri, 11 Nov 2005 17:52:38 -0500

        I have a server where the sql error log is constantly missing events.
    Usually you see when processes were killed, backups, server reboots, etc. I
    have a SQL 2000 SP 3a server that is logging when databases start, a few of
    the database backups, but nothing about processes being killed. The only
    thing I can think of is that auditing is not turned on. Any suggestions? I
    tried cycling the error log, it put an entry that the error log had been
    cycled, then all the SQL server info. I am waiting to see if that does
    anything.

  • Next message: Andrew J. Kelly: "Re: Scripting Permission"

    Relevant Pages

    • Re: Backup software for SBS2003 Standard
      ... I configured my test server with Windows Server 2003 and SCE, which runs on a SQL or MSDE database. ... As you say, I'd continue to do the online Exchange backups, maybe to file so they're included in the SP backups. ... For databases I care about, I do Enterprise Manager backups to file a few times a day, and those get included in the SP backups as well. ...
      (microsoft.public.windows.server.sbs)
    • Re: MSDE OSQL Shutdown
      ... dann den Server herunterfährst könnte genau in dem Moment die Aktion ... Aus Gründen der Datenkonsistenz sollten Datenbanken niemals Offline ... weil alle Backups dazwischen unbrauchbar waren;-) ... Datenbank Verzeichnis des SQL Servers dafür vom Dateibackup aus. ...
      (microsoft.public.de.sqlserver)
    • Re: SQLVDI - Fixed
      ... Fixed it on my problem server. ... the app they use filed on SQL 2005, so I downgraded to SQL 2000 and then ... installed Share Point which installs a version of SQL ... Today the backups completely failed, could not even backup single file ...
      (microsoft.public.windows.server.sbs)
    • Re: Emailing SQL 2000 maintenance report via SMTP?
      ... You can create jobs within the SQL Server Agent that will backup ... > DB maintenance plan just stops doing what it should, ... > today) where I find my backups haven't been working for a month!!! ...
      (microsoft.public.sqlserver.programming)
    • Re: Location of Data
      ... first install), then you will probably reach a point on your second or third ... Moving Data Flolder for Windows Small Business Server 2003 ... >> As far as SQL backups, use SQL Enterprise manager to do at least daily>> backups to your D drive and then let your Backup program bakup the SQL ...
      (microsoft.public.windows.server.sbs)