Comments
Sort by recent activity
So will FILEOPTIONS=5 delete files in both the primary and COPYTO locations?
Thanks / comments
So will FILEOPTIONS=5 delete files in both the primary and COPYTO locations?
Thanks
Great, then how about a change to command then. Allow different file ages between primary and secondary servers.
EG: Only keep the last day on the primary but keep the last 5 days on secondary. / comments
Great, then how about a change to command then. Allow different file ages between primary and secondary servers.
EG: Only keep the last day on the primary but keep the last 5 days on secondary.
The copy was failing due to lack of space on the target system.
Maybe a feature for the future is to provide options for SQL Backup to clean up the "COPYTO" directory as well as the local directory.
Thanks for your help. / comments
The copy was failing due to lack of space on the target system.
Maybe a feature for the future is to provide options for SQL Backup to clean up the "COPYTO" directory as well as the local directory...
So does SQL Backup actually perform another backup when the COPYTO option is used?
We're already using the MAXTRANSFERSIZE = 65536 option.
The network share is available, it is constantly being used for transaction log backups as part of a seperate Log Shipping process.
Maybe in this instance the job should complete with a Warning, or some sort of failure.
Thanks
Phill / comments
So does SQL Backup actually perform another backup when the COPYTO option is used?
We're already using the MAXTRANSFERSIZE = 65536 option.
The network share is available, it is constantly being use...
Thanks for the response David. Unfortunately that didn't help at all and I wasted another few hours on this today before working out what the problem was.
The problem has nothing to do with any of the switches mentioned in the error message, or the square brackets,
/scripts1:"C:\Temp\7000\SQL\"
The path shouldn't have a trailing "\". Once I removed the trailing "\" the command worked without any problems.
I suppose it would be too much to ask that we get a useful error message rather than the red herring :lol:
Cheers
Phil / comments
Thanks for the response David. Unfortunately that didn't help at all and I wasted another few hours on this today before working out what the problem was.
The problem has nothing to do with any of ...
Just as an FYI, the support request number for this is F0059825. / comments
Just as an FYI, the support request number for this is F0059825.
Thanks Brian, eagerly awaiting that update [image] / comments
Thanks Brian, eagerly awaiting that update
Brian
I've replaced the "default" option so my command line now looks like,
&"C:\Program Files (x86)\Red Gate\SQL Compare 10\SQLCompare.exe" /Scripts1:"C:\Temp\2583\SQL" /server2:UATMRISQL01 /database2:KFProd /scriptfile:"C:\Temp\2583\2583.sql" /options:DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IncludeDependencies,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName,IgnorePermissions,IgnoreUsersPermissionsAndRoleMemberships /include:Different /include:StoredProcedure:[eft_ListBrokenEfts]^|[app_CheckRptServer]^|[SendEmailGeneric]
But I still get the "REVOKE" statements included in the script that is generated.
Thanks
Phil
[/code] / comments
Brian
I've replaced the "default" option so my command line now looks like,
&"C:\Program Files (x86)\Red Gate\SQL Compare 10\SQLCompare.exe" /Scripts1:"C:\Temp\2583\SQL" /server2:UATMRISQL0...