Options
Can network copies be on a local drive ?
Ericgagne
Posts: 8
Hello,
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:
Deleting I:\xxxxx
Deleting \\networkshare\xxxxxx
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 ?
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:
Deleting I:\xxxxx
Deleting \\networkshare\xxxxxx
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 ?
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
There is a simple workaround however as it seems that what SQL Backup really needs for this to work is a UNC, but not necessarily on a remote machine.
I changed "E:\SQL Backup Copies" to "\\ServerName\E$\SQL Backup Copies" in my job and it works fine now.