Anyone have a idea why this is happening , I think it could be connectivity related... timeout setting of sorts...

11 percent processed.
22 percent processed.
31 percent processed.
42 percent processed.
51 percent processed.
62 percent processed.
71 percent processed.
82 percent processed.
91 percent processed.
Processed 4480 pages for database 'EvolutionCommon', file 'EvolutionCommon1' on file 1.
100 percent processed.
Processed 2 pages for database 'EvolutionCommon', file 'EvolutionCommon1_log' on file 1.
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "https://ccom.blob.core.windows.net/backups/EvolutionCommon_backup_test.bak:" Backup to URL received an exception from the remote endpoint. Exception Message: Unrecoverable error occurred during Flush operation.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Hi, are you using Proxy Servers to access the internet??

try this

bye

No I am using direct access. and the HTTP and HTTPS ports are open both ways.

Is there enough space on the drive to fit the backup?

Check free space

bye

Yes it is a 5mb database , small for testing.

I played around with sql 2014 and noticed if you dont set the compression settings it uploads a 1tb database... very weird.



Hi David,

I make a test to backup a SQL Server 2012 database and a SQL Server 2014 database to Azure. Everything works as expected and both backups are successful. Below is my screenshot.

Based on my research, the error Backup to URL received an exception from the remote endpoint. Exception Message: Unrecoverable error occurred during Flush operation might be due to endpoint protection. You can create a ticket about such issue to Symantec support. For more details, please review this similar thread.

In addition, for Azure backup issues, for quick and accurate answer, you can post the question in the Azure backup forum at https://social.msdn.microsoft.com/Forums/en-us/1ba9b0fa-3a2e-481d-8a0f-bd851a2e9ed0/problem-with-sql-server-databases-backup?forum=windowsazureonlinebackup.

Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.

I am not running any symantec client on the machine.

I run this command on sql2014 and it works , fails on sql 2012

BACKUP DATABASE [evolutioncommon] TO  URL = N'https://ccom.blob.core.windows.net/mccdl-mssqlserver/evolutioncommon_backup_4.bak' 
WITH  CREDENTIAL = N'AZURE_ccom' , NOFORMAT, NOINIT,  NAME = N'evolutioncommon_backup', SKIP, REWIND, NOUNLOAD, COMPRESSION,  STATS = 10

11 percent processed.
22 percent processed.
31 percent processed.
42 percent processed.
51 percent processed.
62 percent processed.
71 percent processed.
82 percent processed.
91 percent processed.
Processed 4480 pages for database 'evolutioncommon', file 'EvolutionCommon1' on file 1.
100 percent processed.
Processed 3 pages for database 'evolutioncommon', file 'EvolutionCommon1_log' on file 1.
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "https://ccom.blob.core.windows.net/mccdl-mssqlserver/evolutioncommon_backup_4.bak:" Backup to URL received an exception from the remote endpoint. Exception Message: Unrecoverable error occurred during Flush operation.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Even with compression it create a 1TB file and then compresses it

Hi,

For troubleshooting, you can turn on TF3058 and collect the azure storage logs.

The issue is also most likely fixed by applying the latest CU since the thread mentions that it does not repro on SQL 2014.

I have applied the latest CU , the logs dont give me any more info than I have already sent.

the funny thing is that the Azure Backup client works from the same machine.