by I have two servers (SQL 7, sp2; NT4, sp 6a) that are failing to backup the
transaction logs nightly. Occasionally they work, but I don't know for sure
unless I look for the *.trn file. Usually there is nothing written to disk as it
should be. I have deleted the maint plans and recreated -- made no difference.
All other backup jobs are running fine on these servers.
Kicking off the job manually sometimes works, but other times produces the same
results as the scheduled job. See log entry below (DBCC runs, old log files are
deleted, but that's it):
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server 'Myserver' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Mydb' on Mon Jun 04 18:29:38 2001
[1] Database MyStarWars: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 43 secs **
[2] Database MyStarWars: Delete Old Backup Files...
0 file(s) deleted.
Deleting old text reports... 1 file(s) deleted.
End of maintenance plan 'Mydb' on Mon Jun 04 18:30:21 2001
SQLMAINT.EXE Process Exit Code: 0 (Success)
This is very frustrating. This jobs worked for months then started acting
erratically sometime in the last month. I cannot correlate any event with this
failure to backup.
In help/suggestions are greatly appreciated,
TIA,
B. Griswold