Very Computer

I am trying to create a Database Maintenance Plan for taking Backup of my
database and transaction Log. Execution of Database Backup is running fine
but the backup for Transaction Log is giving me hard time. The statement
that I execute is

EXECUTE master.dbo.xp_sqlmaint N'-PlanID
34D0F675-9B8E-4C6A-A978-88D84C11AD77 -To "Sree-ERW" -Rpt "C:\Program
Files\Microsoft SQL Server\MSSQL\LOG\DB Maintenance Plan16.txt" -DelTxtRpt
4DAYS -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpLog "C:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP" -DelBkUps 4DAYS -BkExt "TRN"'

This is what I get on execution of the above statement. Please help me
resoving this issue.

Output of sqlmaint.exe
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
---------------------------
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.194
Copyright (C) Microsoft Corporation, 1995 - 1998
NULL
Logged on to SQL Server 'SREE' as 'SBT' (non-trusted)
Starting maintenance plan 'DB Maintenance Plan1' on 11/14/2002 11:51:53 AM

Backup can not be performed on database 'PlanningAndScheduling'. This sub
task is ignored.
NULL
Deleting old text reports...    0 file(s) deleted.
NULL
End of maintenance plan 'DB Maintenance Plan1' on 11/14/2002 11:51:53 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
NULL
Emailing report to operator 'Sree-ERW'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL
Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80040106

(15 row(s) affected)

Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.

Article Link or resolution or any other help is appreciated.

Thanks in Advance,
-- Sree

Can you run a transaction backup manually?  That will
usually give a better, more descriptive error message for
you if it fails.

Here are some things to check for that could cause failure:
1.  Do you have enough disk space?
2.  What recovery mode are you using (with Simple mode,
you don't have the option to back up the transaction logs)

HTH
Cary

Quote:>-----Original Message-----
>I am trying to create a Database Maintenance Plan for
taking Backup of my
>database and transaction Log. Execution of Database

Backup is running fine

Quote:>but the backup for Transaction Log is giving me hard
time. The statement
>that I execute is

>EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>34D0F675-9B8E-4C6A-A978-88D84C11AD77 -To "Sree-ERW" -
Rpt "C:\Program
>Files\Microsoft SQL Server\MSSQL\LOG\DB Maintenance

Plan16.txt" -DelTxtRpt

Quote:>4DAYS -WriteHistory  -VrfyBackup -BkUpMedia DISK -
BkUpLog "C:\Program
>Files\Microsoft SQL Server\MSSQL\BACKUP" -DelBkUps 4DAYS -
BkExt "TRN"'

>This is what I get on execution of the above statement.
Please help me
>resoving this issue.

>Output of sqlmaint.exe
>----------------------------------------------------------
------------------
>----------------------------------------------------------
------------------
>----------------------------------------------------------
------------------
>---------------------------
>NULL
>Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.194
>Copyright (C) Microsoft Corporation, 1995 - 1998
>NULL
>Logged on to SQL Server 'SREE' as 'SBT' (non-trusted)
>Starting maintenance plan 'DB Maintenance Plan1' on

11/14/2002 11:51:53 AM

Quote:

>Backup can not be performed on

database 'PlanningAndScheduling'. This sub

Quote:>task is ignored.
>NULL
>Deleting old text reports...    0 file(s) deleted.
>NULL
>End of maintenance plan 'DB Maintenance Plan1' on

11/14/2002 11:51:53 AM

Quote:>SQLMAINT.EXE Process Exit Code: 1 (Failed)
>NULL
>Emailing report to operator 'Sree-ERW'
>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025:

[Microsoft][ODBC SQL

Quote:>Server Driver][SQL Server]xp_sendmail: failed with mail
error 0x80040106

>(15 row(s) affected)

>Server: Msg 22029, Level 16, State 1, Line 0
>sqlmaint.exe failed.

>Article Link or resolution or any other help is
appreciated.

>Thanks in Advance,
>-- Sree

>.