Forum Discussion

acidborn60's avatar
acidborn60
Level 4
16 years ago

Backup SQL log error (SQLVDI)

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

  • 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.

4 Replies

  • 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.
  •  Hi! I have the same issue. Did you find any 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.

  • Hello!

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