Comments
Sort by recent activity
Matthew,
It works perfectly. A single quote solution! I never even attempted that angle. I kept creating the -SQL parameter with the same syntax that the GUI creates. You can't imagine my frustration quoting quotes, always thinking a few more in the right place would get the string '''just' + ' ' + 'right'''.
Thank you very much. / comments
Matthew,
It works perfectly. A single quote solution! I never even attempted that angle. I kept creating the -SQL parameter with the same syntax that the GUI creates. You can't imagine my frust...
Thanks for looking into my question. Your example gives a syntax error. When I correct the syntax as I think it should be, I get error 870 (No command passed to SQL Backup). Is it possible to pass a variable to sqlbackup as the -SQL parameter? I manipulate the @cmd string to be a syntactically correct sqlbackup -SQL command and I get exitcode error 870 and a list of parameter options or else I've set the string up incorrectly and get a syntax error. This is only when I try to incorporate @exitcode and @sqlerrorcode.
This works:
select @cmd = 'master..sqlbackup ''-SQL "CONVERT ' + '''''' + @f1 + '''''' + ' to ' + '''''' + @f2 + '''''' + '"' + ''''
exec (@cmd)
I just can't get the exit and error codes with it. / comments
Thanks for looking into my question. Your example gives a syntax error. When I correct the syntax as I think it should be, I get error 870 (No command passed to SQL Backup). Is it possible to pa...
I understand the "copy to" functionality. I don't always have the luxury of available local disk to do that. I will address my issue by having the replication software run in a window when there aren't a lot of full backups going on, instead of the "immediate" option.
I still have the same questions... I wanted to know if there was the potential of failure due to timeout. Apparently there is. Is it always three attempts before failing or is it the duration of the attempt that causes the failure? Why does this happen with SQL Backup and not the TSQL backup command? Thanks. / comments
I understand the "copy to" functionality. I don't always have the luxury of available local disk to do that. I will address my issue by having the replication software run in a window when there ...
I'm getting Warning 175 once or twice a week using 5.3.0.178. I'm sure its the DFS replication software running, copying my backup files to an offsite server. I did a restore VerifyOnly and I'm told the backup set is OK. My question is, what happens? Does SQL Backup just wait until the file is unlocked? Is there the potential for a timeout and error? How come it doesn't happen with the native tsql backup command? / comments
I'm getting Warning 175 once or twice a week using 5.3.0.178. I'm sure its the DFS replication software running, copying my backup files to an offsite server. I did a restore VerifyOnly and I'm t...
This large db has no activity at night when I run the full backup so I added THREADCOUNT = 10 (of possible 16), upped compression from 3 to 4, and knocked 45 minutes off the backup time and 16GB off the backup file. SQL Backup Pro really is a robust product. / comments
This large db has no activity at night when I run the full backup so I added THREADCOUNT = 10 (of possible 16), upped compression from 3 to 4, and knocked 45 minutes off the backup time and 16GB of...
Thank you very much. / comments
Thank you very much.
You'll find this happens fairly often. Task Manager > End Process and restart the gui. / comments
You'll find this happens fairly often. Task Manager > End Process and restart the gui.
Yes ~13 minutes is normal for the 20gb file. I suspect the issues is with the replication of the the COPYTO folder. The COPYTO folder is a DFS share that is replicated offsite. I think the SysAdmins had/have issues with the replication. I'm monitoring, but I believe the problem is with us. / comments
Yes ~13 minutes is normal for the 20gb file. I suspect the issues is with the replication of the the COPYTO folder. The COPYTO folder is a DFS share that is replicated offsite. I think the SysAd...
Thanks for the reply. I'm sure it's the AV. It's ALWAYS the AV [image] / comments
Thanks for the reply. I'm sure it's the AV. It's ALWAYS the AV