Start a Conversation

Unsolved

This post is more than 5 years old

5099

August 20th, 2014 07:00

SQL Backup Complete though Errors in Avamar

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

38 Posts

May 27th, 2015 02:00

we have issue too.

355 Posts

May 27th, 2015 03:00

Hi,

Could you please provide latest logs here ?

Regards,

Pawan

38 Posts

May 27th, 2015 03:00

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

logs:

1 Attachment

226 Posts

April 4th, 2016 20:00

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

No Events found!

Top