Comments
Sort by recent activity
SQL Backup returns an exit code equal to it's error code (as found in the SQL Backup help file). A value of 0 indicates success. You can use the following batch file to try it: @ECHO OFF
e:\temp\_sqlspeedbak\sqlbackupc -sql "backup database pubs to disk = 'c:\temp\pubs.sqb' with init"
IF %ERRORLEVEL% == 0 GOTO success
echo Failed with exit code %ERRORLEVEL%
GOTO end
:success
echo Successful
GOTO end
:end
The GUI does not have the option to send an email only upon failure. However, it can be done if you change the script to use MAILTO_ONERROR instead of MAILTO.
What sort of environment variables are you referring to? / comments
SQL Backup returns an exit code equal to it's error code (as found in the SQL Backup help file). A value of 0 indicates success. You can use the following batch file to try it:@ECHO OFF
e:\temp\_...
Interesting suggestion.
You can just edit the scripts to fit your needs and use them in the extended stored procedure or command line interfaces. The scripts in the GUI are there as a guide, to show how to 'script' each option. However, some of the options are not exposed in the GUI e.g. the LOGTO and ERASEFILESOPTION options, in order to keep things simple.
The help file contains full details of the valid syntax. / comments
Interesting suggestion.
You can just edit the scripts to fit your needs and use them in the extended stored procedure or command line interfaces. The scripts in the GUI are there as a guide, to sh...
This bug report (SB-4420) is still open. So far, we know of only one request to perform the deletion after the file has been successfully copied. Changing the default behavior now would affect all other users, who may be perfectly happy with the deletion happening before the copy. Option would then be to introduce a new keyword e.g. ERASEFILES_AFTERCOPY, but if it's only useful for a handful of users, it wouldn't be feasible for us to add that keyword.
If you can tell us why your files may not always be copied successfully, perhaps we can offer some workarounds for now.
Thanks. / comments
This bug report (SB-4420) is still open. So far, we know of only one request to perform the deletion after the file has been successfully copied. Changing the default behavior now would affect al...
mdgraves wrote:
Is there a seperate process that backup runs at some period to handle work for clean up of MSDB table history, etc.? Or does this happen during each run?
It happens during each run. / comments
mdgraves wrote:
Is there a seperate process that backup runs at some period to handle work for clean up of MSDB table history, etc.? Or does this happen during each run?
It happens during each ...
Could you please check the version of xp_sqlbackup.dll that's currently installed on your system? It's installed in SQL Server's Binn folder e.g. [image] \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn. Could you also please check the version of the SQL Backup Agent service (SQBCoreService.exe) that's installed? The default installation folder is C:\Program Files\Red Gate\SQL Backup 6\<instance name>.
Also, the next time this occurs, could you please run sp_who2, and see if there is any backup process running/pending, and if it's blocked by another process?
Thanks. / comments
Could you please check the version of xp_sqlbackup.dll that's currently installed on your system? It's installed in SQL Server's Binn folder e.g. \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\...
Those 8 backups appear to have run to completion, but for some reason, the last backup isn't returning results to SQL Server. Are the BACKUP commands all that is being run in the job, or are there subsequent commands?
You can send the image to the following e-mail address: peter.yeoh@red-gate.com.
Yes, it would be worth a try reverting to 6.2 to see if the same error occurs.
Thanks. / comments
Those 8 backups appear to have run to completion, but for some reason, the last backup isn't returning results to SQL Server. Are the BACKUP commands all that is being run in the job, or are there...
The stack trace seems to have been generated on 2010-11-30, 10:38. You mentioned that the backup usually hangs at 11 pm. Was this after one of the times when the backup hanged?
Is so, the stack trace doesn't show any backups running or waiting to run. Could you please check if a log was generated for the backup process that started at 11 pm? The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.
Thanks. / comments
The stack trace seems to have been generated on 2010-11-30, 10:38. You mentioned that the backup usually hangs at 11 pm. Was this after one of the times when the backup hanged?
Is so, the stack t...
When you run 'sqbutility 9997', the output is NULL, but a stack trace should have been generated. This stack trace is then stored in a file named SQBCoreService_<instance name>_bugreport.txt, and is located in 'C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\' on Windows 2003 and older, and 'C:\ProgramData\Red Gate\SQL Backup\Log\' on Windows Vista and newer.
Also, what is the backup command that you are running?
Thanks. / comments
When you run 'sqbutility 9997', the output is NULL, but a stack trace should have been generated. This stack trace is then stored in a file named SQBCoreService_<instance name>_bugreport.txt, and ...
The logs indicate that the backup was successful. That would suggest that a post-backup process within SQL Backup has failed.
Could you please look at this article, and try to generate the stack trace of the SQL Backup process for us to troubleshoot further?
Thanks. / comments
The logs indicate that the backup was successful. That would suggest that a post-backup process within SQL Backup has failed.
Could you please look at this article, and try to generate the stack t...
What do you mean by 'interderminate as to how many files will be extracted'? Thanks. / comments
What do you mean by 'interderminate as to how many files will be extracted'? Thanks.