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.
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)
