I was adding databases to an availability group (SQL Server 2017 CU20 instance) the other day and one database failed to automatically seed to the secondary.
When I looked in the SQL Server error log I saw this error message: –
BackupIoRequest::ReportIoError: write failure on backup device ‘{GUID}’. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Followed up by: –
Automatic seeding of availability database ‘databasename’ in availability group ‘availabilitygroup’ failed with a transient error. The operation will be retried.
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device ‘{GUID}’. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Write on “{GUID}” failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
A nonrecoverable I/O error occurred on file “{GUID}:” 995(The I/O operation has been aborted because of either a thread exit or an application request.).
OK I was a little concerned…until I went and checked the secondary.
The issue was, even though I’d created the file paths on the secondary for the data files…I hadn’t created the file path for the database’s log file.
So I removed the database from the availability group, created the file path for the database’s log file, and readded to the availability group.
This time the database automatically seeded over to the secondary no problem…phew!
Thanks for reading!