COPYTO failed after Mirror failure
I had a Mirror failure which required me to ship the logs, which I used Red Gates log shiping, to my secondary server to restore before I could re-initialize the server to be the mirror. After which all my log backups fail to COPYTO the network location for my snap to pick it up. What do I need to do to get this working again.
When I do Prints of my variables, everything is correct with path and filenames, they just dont make it there.
Here is my backup script with Backup 6:
SET @sql_string = '-SQL "BACKUP LOG ' + @dbname + ' TO DISK = ''' +
@file_name + ''' WITH COMPRESSION = 2, ERASEFILES = 1b, ' +
' COPYTO = ' + '''' + @directory + '''' +
' ,MAXDATABLOCK = 524288, MAXTRANSFERSIZE = 524288, ERASEFILES_REMOTE = 1, ' +
' FILEOPTIONS = 3, DISKRETRYINTERVAL = 90, DISKRETRYCOUNT = 2"'