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
Comments
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 :)
Would you like to reply?
Login or Register to post your comment.