2

After a reboot we encounter while the first backup (wbadmin) on a Windows Server 2016 these errors in the eventlog:

  • Source: SPP
  • Event ID 16389
  • Details: The writer's timeout expired between the Freeze and Thaw events (0x800423f2)

Weak hardware
The server has only sata drives and the controller has no (buffered) cache (Dell T130; H330 controller).

Errors only after reboot
The errors occour while backing up MSSQL databases. We also encounter SQLWRITER errors and errors from the SQL Server itself while the backup is running. But the backup itself completes without prompting any error and until the next reboot the following backups are perfomed without any errors in the eventlog.

In the errorlog of the sql server I can see for every database:

2018-11-02 01:16:37.34 Backup      BACKUP failed to complete the command BACKUP DATABASE <name of database> Check the backup application log for detailed messages.  

vssadmin list writers: All writers report stable and no errors

Possible soulution?
We found hints to increase the SPP "CreateTimeout" to 20 minutes

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\SPP\CreateTimeout  

Is this an appropriate way to solve the problems?

May this cause any other problems?

marsh-wiggle
  • 2,075
  • 4
  • 26
  • 44

1 Answers1

0

We found this Microsoft Document: Windows Server Backup failed ....

And changed "CreateTimeout":

Resolution:

  • Run regedit.exe and navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\SPP
  • Create a new Registry value of type DWORD with name CreateTimeout
  • Change value to 12000000 (21060*1000 = 20 mins) in decimal

Since that, even after reboots, no errors are reported in the eventlog and the sql server logs.

hurikhan77
  • 567
  • 3
  • 9
  • 22
marsh-wiggle
  • 2,075
  • 4
  • 26
  • 44