Backup issue
Hi, we are using 6.4 version, and here is the command
-SQL "BACKUP DATABASES [di_repo,etl_stage,parameters_bi,son_db_bi] TO DISK = 'F:\MSSQL.1\MSSQL\Backup\<AUTO>.sqb' WITH ERASEFILES = 5h, ERASEFILES_REMOTE = 4, MAILTO = 'xdai@fulbright.com', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 2, COPYTO = 'H:\MSSQL\Backup', THREADCOUNT = 23 "
though i specify the folder which backup copy to, should still remain 4 days copy(ERASEFILES_REMOTE = 4), but it still remove all, why is that?
thanks
-SQL "BACKUP DATABASES [di_repo,etl_stage,parameters_bi,son_db_bi] TO DISK = 'F:\MSSQL.1\MSSQL\Backup\<AUTO>.sqb' WITH ERASEFILES = 5h, ERASEFILES_REMOTE = 4, MAILTO = 'xdai@fulbright.com', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 2, COPYTO = 'H:\MSSQL\Backup', THREADCOUNT = 23 "
though i specify the folder which backup copy to, should still remain 4 days copy(ERASEFILES_REMOTE = 4), but it still remove all, why is that?
thanks
Comments
I see from your script that the TO DISK path and the COPYTO path are both local disk paths.
When this occurs, the ERASEFILES parameter overrides the ERASEFILES_REMOTE parameter, so that both locations use the ERASEFILES parameter.
If you set the COPYTO path to be the expected network share in unc path format, \\server\share_name, the ERASFILES_REMOTE parameter will be used.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com