SQL Backup Complete though Errors in Avamar

Question

Good Morning, I have a database that I'm trying to backup through Avamar. It's a somewhat large database (>500gb) but has very static data. In Avamar, I've set up a job that runs every four weeks, and the backup expires every five weeks, so I always have a fresh enough backup in the Avamar Grid. This is a Windows Server 2012 VM running SQL Enterprise 2012. In theory. Normally, I'd run the backup to disk and let Avamar backup the backup files. In this case, there is not enough disk space to allow this. To me, it looks as if the SQL backup is completing: Log Name: Application Source: MSSQLSERVER Date: 8/16/2014 11:17:50 AM Event ID: 18264 Task Category: Backup Level: Information Keywords: Classic User: SYSTEM Computer: SQLNAME Description: Database backed up. Database: Imagery, creation date(time): 2014/06/16(11:59:40), pages dumped: 54445673, first LSN: 892722:29787:103, last LSN: 892722:29839:1, number of dump devices: 2, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'(local)_Imagery_SQL_Monthly_Full-SQL_Servers_Monthly-1408197600113#1-3006-SQL', 'vd_1'}). This is an informational message only. No user action is required. Though looking at the Avamar log, I see this: 2014-08-16 10:00:01 avtar Error <16141>: This version of Avtar does not support this specific version of Windows OS. Avtar will continue, but the operation may not complete successfully. ... Log #3: avsql log 2014-08-16 09:59:59 Eastern Daylight Time [6.1.100-402 Windows Server 8 Datacenter Server Edition (No Service Pack) 64-bit-AMD64] 2014-08-16 09:59:59 avsql Info <5008>: Logging to C:\Program Files\avs\var\SQL_Monthly_Full-SQL_Servers_Monthly-1408197600113-3006-SQL.log 2014-08-16 09:59:59 avsql Info <6673>: CTL listening on port 51218 2014-08-16 09:59:59 avsql Info <10684>: Setting ctl message version to 3 (from 1) 2014-08-16 09:59:59 avsql Info <16136>: Setting ctl max message size to 268435456 2014-08-16 09:59:59 avsql Warning <6788>: Found unknown section 'browse-from-catalog' in workorder, ignoring 2014-08-16 09:59:59 avsql Warning <6788>: Found unknown section 'browse-from-catalog' in workorder, ignoring 2014-08-16 09:59:59 avsql Info <7838>: - Adding user exclude '*/tempdb' 2014-08-16 09:59:59 avsql Info <7062>: Targets count 1 2014-08-16 09:59:59 avsql Info <7063>: target[0] = '(local)/Imagery' 2014-08-16 09:59:59 avsql Warning <6788>: Found unknown section 'browse-from-catalog' in workorder, ignoring 2014-08-16 09:59:59 avsql Info <7065>: Working on target '(local)/Imagery/f-0' 2014-08-16 09:59:59 avsql Info <14293>: Creating a database task for '(local)/Imagery/f-0' (hcount 157) 2014-08-16 10:00:00 avsql Info <14245>: Creating a thread pool with 2 worker threads. 2014-08-16 10:00:00 avsql Info <14248>: Executing task: (local)/Imagery/f-0 --> vd_streams[2] 2014-08-16 10:00:00 avsql Info <14250>: VDI SQL Instance: 2014-08-16 10:00:01 avsql Info <14266>: Executing the data transfer task: (local)/Imagery/f-0.stream0 2014-08-16 10:00:01 avsql Info <14266>: Executing the data transfer task: (local)/Imagery/f-0.stream1 2014-08-16 10:00:01 avsql Info <9552>: Spawning 'C:\Program Files\avs\bin\avtar' (avtar --case_sensitive='false' --max-streams='1' --backup-type='level0_full' --cacheprefix='avsql_t1' --ctlcallport='51218' --ctlinterface='3006-SQL-SQL Monthly Full-SQL Servers Monthly-1408197600113#1#1' --check-stdin-path='false' --logfile='C:\Program Files\avs\var\SQL_Monthly_Full-SQL_Servers_Monthly-1408197600113#1#1-3006-SQL.avtar.log' --vardir='C:\Program Files\avs\var' --bindir='C:\Program Files\avs\bin' --sysdir='C:\Program Files\avs\etc' --acnt='/clients/SQLServers/SQLNAME' --id='backuponly' --ap='backuponly1' --server='avamarbk') 2014-08-16 10:00:01 avsql Info <9552>: Spawning 'C:\Program Files\avs\bin\avtar' (avtar --case_sensitive='false' --max-streams='1' --backup-type='level0_full' --cacheprefix='avsql_t0' --ctlcallport='51218' --ctlinterface='3006-SQL-SQL Monthly Full-SQL Servers Monthly-1408197600113#1#0' --check-stdin-path='false' --logfile='C:\Program Files\avs\var\SQL_Monthly_Full-SQL_Servers_Monthly-1408197600113#1#0-3006-SQL.avtar.log' --vardir='C:\Program Files\avs\var' --bindir='C:\Program Files\avs\bin' --sysdir='C:\Program Files\avs\etc' --acnt='/clients/SQLServers/SQLNAME' --id='backuponly' --ap='backuponly1' --server='avamarbk') 2014-08-16 10:00:01 avsql Warning <6055>: Unable to determine child process initialization state 2014-08-16 10:00:01 avsql Info <6686>: Process 4960 (C:\Program Files\avs\bin\avtar) for workorder SQL Monthly Full-SQL Servers Monthly-1408197600113#1#1 started 2014-08-16 10:00:01 avsql Warning <6055>: Unable to determine child process initialization state 2014-08-16 10:00:01 avsql Info <6686>: Process 616 (C:\Program Files\avs\bin\avtar) for workorder SQL Monthly Full-SQL Servers Monthly-1408197600113#1#0 started 2014-08-16 10:00:01 avsql Info <10684>: Setting ctl message version to 3 (from 1) 2014-08-16 10:00:01 avsql Info <16136>: Setting ctl max message size to 268435456 2014-08-16 10:00:01 avsql Info <10684>: Setting ctl message version to 3 (from 1) 2014-08-16 10:00:01 avsql Info <16136>: Setting ctl max message size to 268435456 2014-08-16 10:00:04 avsql Warning <6788>: Found unknown section 'browse-from-catalog' in workorder, ignoring 2014-08-16 11:17:50 avsql Info <7732>: Waiting for avtar to finish 2014-08-16 11:17:50 avsql Info <7732>: Waiting for avtar to finish 2014-08-16 11:17:52 avsql Info <6688>: Process 616 (C:\Program Files\avs\bin\avtar) finished (code 536870932: completed with errors, client log should be examined) 2014-08-16 11:17:52 avsql Warning <6690>: CTL workorder 'SQL Monthly Full-SQL Servers Monthly-1408197600113#1#0' non-zero exit status 'code 536870932: completed with errors, client log should be examined' 2014-08-16 11:17:52 avsql Info <6444>: Plugin exited with 'code 536870932: completed with errors, client log should be examined' 2014-08-16 11:17:55 avsql Info <6688>: Process 4960 (C:\Program Files\avs\bin\avtar) finished (code 536870932: completed with errors, client log should be examined) 2014-08-16 11:17:55 avsql Warning <6690>: CTL workorder 'SQL Monthly Full-SQL Servers Monthly-1408197600113#1#1' non-zero exit status 'code 536870932: completed with errors, client log should be examined' 2014-08-16 11:17:55 avsql Info <6444>: Plugin exited with 'code 536870932: completed with errors, client log should be examined' 2014-08-16 11:17:55 avsql Info <6446>: SQL VDI transfer of '(local)/Imagery/f-0' to '(local)_Imagery_SQL_Monthly_Full-SQL_Servers_Monthly-1408197600113#1-3006-SQL' successful 2014-08-16 11:17:55 avsql Info <14275>: There is no more tasks to process. 2014-08-16 11:17:55 avsql Info <14271>: Waiting for worker threads to finish ... 2014-08-16 11:17:55 avsql Error <14272>: There are no successfully finished database tasks! 2014-08-16 11:17:55 avsql Error <14294>: An error occurred when generating sql metadata 2014-08-16 11:17:55 avsql Info <7271>: Final summary generated subwork 1, cancelled/aborted 1, snapview 0, exitcode 536870919 2014-08-16 11:18:00 avsql Info <6451>: avsql returning with exitcode 536870919

Allbertik · Answer

we have issue too.

pawankumawat · Answer

Hi, Could you please provide latest logs here ? Regards, Pawan

Allbertik · Answer

I wanted to restore SQL database but for some reason turned out to restore the files with the extension f-0.stream1 logs:

gautamgp · Answer

That's the right file. Whenever you restore SQL database as files, its restored as stream files. You can directly import that to SQL.

Avamar

Was this post helpful?