Activity overview
Latest activity by jimclark
Determine the Backup Folder in TransactSQL
Can I retrieve the SQL Backup backup folder using TransactSQL with the SQBUtility or in some other way?
Peter,
Thank you for the fast response! I installed the both of the patched files (SQBCoreService.exe and SQLBackupC.exe) since both were in the zip and created the new registry entry and set the value to 10.
The log backup copying process now copies all of my log backups each minute keeping the queue small! / comments
Peter,
Thank you for the fast response! I installed the both of the patched files (SQBCoreService.exe and SQLBackupC.exe) since both were in the zip and created the new registry entry and set the ...
Our instances have hundreds of databases and we make hourly log backups which are copied to another storage devices. The log copy queue issues were a significant problem for us but we were able to address them just enough to satisfy our needs by adding some registry entries listed in the help on the "Log Copy Queue" page.
The entries are:
COPYTO:CopyIntervalInMinutes
COPYTO:ThreadCount
The max for thread count is 10 so I set that to 10 and set the copy interval to 1 minute. This was just enough to allow our backups to copy over before the next transaction log backup job launched.
In testing this it appeared that the copying used a fairly naïve algorithm, basically copying <COPYTO:ThreadCount> files once every <COPYTO:CopyIntervalInMinutes> or something that performs similarly. So copying a large number of files takes a long time, even if the files are very small. Actually, it is a little more sophisticated than that, because it seems to be copying more than <COPYTO:ThreadCount> files at a time, but it appears to copy 20 or so files then do nothing for <COPYTO:CopyIntervalInMinutes>.
At any rate, creating those registry entry seems to have speed things up considerables!
i hope that helps someone. / comments
Our instances have hundreds of databases and we make hourly log backups which are copied to another storage devices. The log copy queue issues were a significant problem for us but we were able to...