Error when doing Object Level Recover from Amazon S3 storage

Stefan 1 Reputation point
2021-03-23T00:00:11.933+00:00

I have a problem when trying to perform OLR from backup on Amazon S3 storage that is slightly over 1GB. When I try to perform from the local storage, full table is restored, but when do the same from S3, table is recovered partially (2-3%). I found in SQL error logs that SQL Server end threads with error:

Error: 4014, Severity: 20, State: 11. A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 109, output error: 0).

Backup was made using VDI technology and environment was Windows Server 2016 and SQL Server 14.0.1000.169

I tried solutions found on net, like shut off TCP chimney or RSS but that's not help at all.

What could be the problem here and how can I overcome the problem?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,793 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,200 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Xiaowei He 9,871 Reputation points
    2021-03-23T09:40:47.837+00:00

    Hi,

    According to your description, it seems you meet an issue when using the third-party backup tool to backup the SQL database. Since we are not familiar with Amazon S2 storage, and there's limited information about the issue on Internet, it's recommended to open a case with MS to check if the issue is Windows related. It's also recommended to turn to Amazon S3 community to check if you may get better help.

    Below is the link to open a case with MS：

    https://support.microsoft.com/en-us/gp/customer-service-phone-numbers

    Thanks for your time!
    Best Regards,
    Anne

    -----------------------------

    If the Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments