Comments
Sort by recent activity
Eddie, Thank you for the quick response. This did answer my question and created a new question in regards to the same COPYTO for log files. As a note: The "new way" (without the USESIMPLECOPY) started writing to the remote folder after I submitted the initial question. I believe I restarted the SQL Backup Agent service and this somehow "jump-started" the Log Copy process. I've tested now the same command with and without the USESIMPLECOPY and the Log backup files are being written to the remote folder. I like the immediate action of the USESIMPLECOPY, however I like that the Log Copy Queue will keep trying until (for the most part) the file is copied to the remote folder (in reading about the USESIMPLECOPY if the remote folder is not available that copy could fail...). The "New Question" that comes up is that the ERASEFILES_REMOTE seems to not work on Log files and I don't see anything in either they BACKUP command documentation or the Log Copy Queue documentation that would tell me why. I have also tried the ERASEFILES with ERASEFILES_REMOTE combination and the ERASEFILES_PRIMARY with ERASEFILES_SECONDARY and while the "local" files are cleaned up as I would expect nothing happens in either case with Log files on the remote folder. I have similar backups for non-Log files with ERASEFILES and ERASEFILES_REMOTE and those work as I would expect. Just with Log files it does not work correctly. I think I may be missing something. Thank you. / comments
Eddie,Thank you for the quick response. This did answer my question and created a new question in regards to the same COPYTO for log files.As a note: The "new way" (without the USESIMPLECOPY) star...