| Author |
Topic |
|
carau2007
Starting Member
31 Posts |
 Posted - 2007-09-27 : 09:49:43
|
| Hi,I am using SQL server 2000 and I created a maintenance plan. I started the jobs manually for the first time to see if everything will do as it's supposed to do before the scheduel takes place.The DB backup are successful. When I start the Transaction Log backup job it returns failed. But when I look on the actual server ine the default directory the transaction logs are there with the current date and time.Why do I always get a failed message. It says in the job history - The job failed. The job was invoved by user xxxxx. The last step to run was step 1(step 1).Does anyone have an idea why I get this message. Also it says that is notified me by net send and it never does. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 09:53:55
|
| It may be the NET SEND that is the thing that is failing then (i.e. rather than the backup)There is an option to click (checkbox I think) to show the individual steps, that may shed a bit more light, plus have a look at the TXT report file that Maintenance Plan can generateKristen |
 |
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-27 : 09:59:36
|
| O.k here is the details stepExecuted as user: NT Authority/system.sqlmaint.exe failed (sqlstate 42000)(error 22029). The step failed.I will try to start the transaction log backup again withtout the net send to see if I get the same error. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 10:00:30
|
| Well, I'm afraid this is the problem with the Maintenance Plans. When they fail they don;t give much clue.Perhaps have a look at the Report file and see if that sheds any further light? |
|
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-27 : 10:00:41
|
| Where can I find the TXT report that you mentionned |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 10:03:47
|
| The final step of the Maintenance Wizard allows config of a Report File (and retention period for the Report File).That will show the path (or you can set one up and re-run the job to then get the file)Kristen |
|
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-27 : 10:07:29
|
| Here is the report I think it says something important at the endMicrosoft (R) SQLMaint Utility (Unicode), Version Logged on to SQLServer 'Sxxxxx' as 'NT AUTHORITY\SYSTEM' (trusted)Starting maintenance plan 'DB Backup' on 27/09/2007 9:35:48 AM[1] Database Axxx: Transaction Log Backup... Destination:[e:\mssqlsrv\MSSQL\BACKUP\AdMail\Axxx_tlog_200709270935.TRN] ** Execution Time: 0 hrs, 0 mins, 1 secs **[2] Database Axxx: Verifying Backup... ** Execution Time: 0 hrs, 0 mins, 1 secs **End of maintenance plan 'Databases Backup' on 27/09/2007 9:36:14 AMSQLMAINT.EXE Process Exit Code: 1 (Failed)Emailing report to operator 'Cxxxx'[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18035: [Microsoft][ODBCSQL Server Driver][SQL Server]xp_sendmail: Your SQL Server Service isrunning under the local system account. You need to change your SQLServer Service account ro run under a domain account in order tocomplete this operation |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 10:12:00
|
| Yup! Plus it is telling you that the BACKUP did work.Your SQL Server is not configured to be able to send Email (or perhaps it was set up correctly, with a Domain account, but has since been changed to use Local System account). (I didn't think that was a requirement for NET SEND ... but maybe it is ... OTOH is your Maintenance Plan ALSO set up to try to send an EMail?)Kristen |
|
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-27 : 10:18:31
|
| What does OTOH mean? I did try to send it with an email and it faild. But my real problem now is the transaction logs. I removed all the notifications (net send, email) and I still get a failed message. When I can see by the log the TRN are getting backup. Why am I still getting a failed message. Is does not give me this failed message with the backup job and it has the notification on. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 10:22:58
|
| OTOH = On the other handAnything useful in the Report File for the new job, without any notifications?There are, supposedly, issues with SQL 2000 maintenance plans being re-saved (such as Tlog backup files not getting deleted after the retention period has expired) which are solved by deleting and recreating the plan. Bit of a bore, but might be worth a try.Kristen |
|
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-27 : 10:24:14
|
| O.k wait in the log there is a couple of data base that says Back can not be performed on database master. This sub task is ignored. |
|
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-27 : 10:29:11
|
| Ya I did recreate the maintenance plan. Could it be because I have over 30 database and use the option all database in the maintenane plan. Should I run two maint. plan one for the backup and one for the transaction log. Or have two maint. plan and spit the database? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 11:14:44
|
"says Back can not be performed on database master"If this is a Transaction Log backup then that's right. Master database uses SIMPLE Recovery model, and therefore does not support TLog backup.Another failing of Maintenance Plans I'm afraid  Ideally you want to have a Main Plan that includes ALL databases - so if you crate a new database you don;t have to remember to also add it to the backup ...You might be able to set up the plan for "All user databases" - provided that all your databases will be in Full recovery model.Then set up separate plan for all System databases, and skip the Tlog backup for them.Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-27 : 23:56:29
|
| Turn off verify then try again. |
|
|
|
|
Failed transaction log