Backup SQL log error (SQLVDI)

[acidborn60]

Hi!

I have problem with backup log.

Application log on client  contains this:

Event Type:    Error
Event Source:    SQLVDI
Event Category:    None
Event ID:    1
Date:        20.11.2008
Time:        3:05:10
User:        N/A
Computer:    VSQLF41
Description:
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=2588. Thread=3940. Client. Instance=. VD=Global\VNBU0-2588-3940-1227139209_SQLVDIMemoryName_0.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

If restart backup log policy, backup log not completed. But if start full backup policy manualy and after compleeted start backup log policy - all ok.

Client configuration: windows  2003 sp2 x64, sql 2005 sp2 x64, veritas client 6.5.2 x64

[acidborn60]

INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3294.00 (X64)
Oct  3 2008 00:51:23
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup_log.bch, Op# = 1
INF - Using backup image vSQLF31.MSSQL7.VSQLF31.trx.BUH.~.7.001of001.20081121010012..C
INF - backup log "BUH" to VIRTUAL_DEVICE='VNBU0-2220-4072-1227218413' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <vSQLF31>. Connection timeout is <300> seconds.
ERR - Error in GetConfiguration: 0x80770003.
    CONTINUATION: - The api was waiting and the timeout interval had elapsed.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <4214><[Microsoft][SQL Native Client][SQL Server]BACKUP LOG cannot be performed because there is no current database backup.>.
DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]BACKUP LOG is terminating abnormally.>
ERR - Error found executing <backup log "BUH" to VIRTUAL_DEVICE='VNBU0-2220-4072-1227218413' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
ERR - Error in VDS->Close: 0x80770004.
    CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup_log.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 303(303) seconds.

[ako]

 Hi! I have the same issue. Did you find any solution?

[MKT · Accepted solution]

From your log snippet:

BACKUP LOG cannot be performed because there is no current database backup

Has a full backup been run against these db's?  The log indicates that it's a transaction log backup attempting to run.

[acidborn60]

Hello!

Yes, in sql server agent have job "backup log with truncate". I disable this job and all ok :)