First of all apologies if I'm not posting this in the right section, just started my career as Jnr Dba in a new company & I will have several questions to ask. For example
We currently have monthly backups running at the 1st of each month for our production DBs, these are scheduled by Litespeed console (like any other backup schedule we've got set up) and included in a maintenance plan.
Now the monthly backup for one of the servers which I believed it run gives me an error on the sql job monitor, however when I check the location in where the backup files are held, everything is there, each file with the right size; for some reason I do not have a log report on the server itself, seems to be blank however on the log file summary I get this:
Executed as user: xxx\SQL_AGENT_USER. ...B34' with Windows Authentication Logged on to SQL Server 'xxx' Starting maintenance plan '##DBA - Backup' on 01/11/2016 03:05:13  Enum database list... Selected database list: abc def klm nop ghs qwe  Execution Time: 0 hrs, 0 mins, 1 secs.  Database "abc": Backup database... SQL> Processed 12990680 pages for database 'abc', file 'abc' on file 1. SQL> Processed 39 pages for database 'abc', file 'abc' on file 1. SQL> BACKUP DATABASE successfully processed 12990719 pages in 1513.398 seconds (70.318 MB/sec). Backup added as file number: 1 Output File(s): \\18.104.22.168\DB_Backups\Monthly\x\xxx\abc_db_xxx_2016-11-01-030513_Tue_.bak Native Size: 101... The step failed.
Server type sql server 2000 8.00.2305
did this job fail even though on the server I can see the backup files?
did it fail for only one DB, "abc"?
Where else can I find a more detailed report if the job log file on the server is blank?
I hope I've been clear enough, apologies again if this is not the right section.
Thanks for all your help
To know where you're heading, you gotta know where you been :alien: