October 12, 2004 at 11:06 am
Hi,
I created a maintenance plan for my database for complete backup weekly and log backup for every 2 hours.
i am getting the below error
**************************
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SHANKAR' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 10/12/2004 9:00:17 PM
[1] Database SumanALL: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'SumanALL'. This sub task is ignored.
End of maintenance plan 'DB Maintenance Plan2' on 10/12/2004 9:00:20 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
October 15, 2004 at 8:00 am
This was removed by the editor as SPAM
October 15, 2004 at 11:13 am
Have you looked in Event Viewer on the server? Look in the Application Log. Sometimes you'll get more descriptive info there.
October 16, 2004 at 5:25 am
Hi,
I could found the reason for that .
1. Recovery model is SIMPLE .So i change it to FULL
2. Disk space was less ... Removed some junk data.
now ..its working fine
regards
VENU
October 18, 2004 at 9:09 am
Becareful! It was failing due to the fact you were trying to do a transaction log backup on a database set to simple mode. You can always exclude that database from the transaction log backup part of your main plan. The reason I suggest this is you may find yourself running out of disk space or dealing with large transaction logs on that database now that you didn't have to deal with before.
Wes
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply