Can network copies be on a local drive ?
The server onto which I was pushing copies died and we had to put them somewhere else so I changed my jobs to use a local drive.
Backups are put in I:\SQLBackups and network copies are put in "E:\SQLBackup Copies". Since I did that the copies stopped being deleted automatically and I keep running out of space on my E: drive.
Does SQLBackup support using a local drive for "network copies" ? Could that be why the files aren't deleted ?
The strange thing is that I'm not getting any errors, the remote_erase flag seems to be ignored by the job, it looks like it's not even trying to delete since there's nothing in the log about this.
When I had the network copies on an actual network share, the logs would say:
Since I started using the local E: I only see "Deleting I:\xxxxx" in the log, nothing about the copy.
Is it possible that SQLBackup can create copies on local drives but not delete them ?