I recently started deploying the new SQL Backup 8 application to my development environment. I am getting RedGate Error 790 (Thread 0 error) on several servers. These errors occur on different databases. These errors occur on different backup days. The errors have occured on both physical hardware and VM Guests.
The last SQL Error can be one of the following:
SQL error 5901: One or more recovery units belonging to database '<DBName>' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database
corruption. Examine previous entries in the error log for more detailed information on this failure.
SQL error 1222: Lock request time out period exceeded.
My Activity Log shows the following parameter values:
BACKUP DATABASE [msdb] TO VIRTUAL_DEVICE = 'SQLBACKUP_64D49B7F-BE59-4E78-8D85-A6FDD62CC71F' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (msdb), 7/23/2016 5:29:10 AM', DESCRIPTION = N'Backup
on 7/23/2016 5:29:10 AM Server:<SQLServer> Database: msdb', FORMAT, CHECKSUM
I believe that BLOCKSIZE & MAXTRANSFERSIZE are the defaults. Should these be changed in SQL Backup 8?
Thanks,
Statistics: Posted by jcricegp — Mon Jul 25, 2016 1:14 pm