make sure @nvcFolder is accessible from the server. if the default backup location is not accessible it will give failed error.
exec dtasp_BackupAndPurgeTrackingDatabase
0, --@nLiveHours tinyint, --Any completed instance older than the live hours +live days
1, --@nLiveDays tinyint = 0, --will be deleted along with all associated data
30, --@nHardDeleteDays tinyint = 0, --all data older than this will be deleted.
'C:\DTABackup', --@nvcFolder nvarchar(1024) =N'C:\DTABackup' , --folder for backup files
null, --@nvcValidatingServer sysname = null,
0 --@fForceBackup int = 0 --
No comments:
Post a Comment