Activity overview
Latest activity by vshih
I await this functionality with bated breath. / comments
I await this functionality with bated breath.
It's a USB drive connected to the server. The copies to that drive location work fine, but not the deletes. / comments
It's a USB drive connected to the server. The copies to that drive location work fine, but not the deletes.
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [...] TO DISK = ''D:\Backups\SQLServer\<database>\<AUTO>.sqb'' WITH ERASEFILES = 4b, ERASEFILES_REMOTE = 3b, FILEOPTIONS = 1, MAILTO = ''...'', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 2, COPYTO = ''G:\Backups\SQLServer'', THREADCOUNT = 7"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
Note that I added the FILEOPTIONS directive manually. Previously it was not there, but that configuration did not work either. / comments
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [...] TO DISK = ''D:\Backups\SQLServer\<database>\<AUTO>.sqb'' WITH ERASEFILES = 4b, ERASEFILES_REM...
What is the current state of this issue? I am running SQL Backup 6.4.0.56, I've tried specifying FILEOPTIONS = 1 manually, and it still does not remove old backups from the remote copy location. / comments
What is the current state of this issue? I am running SQL Backup 6.4.0.56, I've tried specifying FILEOPTIONS = 1 manually, and it still does not remove old backups from the remote copy location.