shani19831 (5/21/2012)
Hi guysI'm having trouble on finding out what causing this error on one of out sql servers.
Date: 5/21/2012 Source: MSSQLSERVER
Time: 3:00:00 AM Category (6)
Type: Error Event ID 17055
User: NT AUTHORITY\SYSTEM
Computer: 'sqlserver name'
Description
3041:
BACKUP failed to complete the command dump tranXpBL with truncate_only
dump tran PXBL with truncate_only
dump tran CMBL with truncate_only
dump tran RPBL with truncate_only
dump tran WRHBL with truncate_only
dump tran TLBL with truncate_only
dump tran Rep
Do you guys have any idea on what causes this errors and how to resolve them?
I had searched on GOOGLE but there seems to be loads of typical errors but no exact resolution.
Your effort will be highly appreciated.
Regards,
Shani
that syntax is pretty old - but since it's sql 7/2000 its legitimate (although i use backup log with truncate_only)
run the command sp_helpdb and check if your databases are in simple or full recovery mode - if they are in simple this would explain the issue - if they are in full then i'd advise changing them to simple (as you're not using log backups anyway)
MVDBA