Activity overview
Latest activity by Paula
Here is the code, but it doesn't remove the files.
set @strsql =
'EXECUTE master..sqlbackup ''-SQL "BACKUP DATABASE test TO DISK = ''''\\share\temp\test.sqb'''' WITH ERASEFILES = 7, ERASEFILES_REMOTE = 7, FILEOPTIONS = 1, COPYTO = ''''\\machinename\d$\temp\'''', INIT, THREADCOUNT = 2"'', @exitcode OUT, @sqlerrorcode OUT'
EXECUTE sp_executesql @strsql, @ParmDefinition, @exitcode=@ecode OUTPUT, @sqlerrorcode=@secode OUTPUT ; / comments
Here is the code, but it doesn't remove the files.
set @strsql =
'EXECUTE master..sqlbackup ''-SQL "BACKUP DATABASE test TO DISK = ''''\\share\temp\test.sqb'''' WITH ERASEFILES = 7, ERASEFILES_REMO...