Comments
Sort by recent activity
This would be a great log shipping feature enhancement. / comments
This would be a great log shipping feature enhancement.
The debug version of xp_sqlbackup.dll seems to have fixed the problem with the GUI client. / comments
The debug version of xp_sqlbackup.dll seems to have fixed the problem with the GUI client.
As I stated earlier: The debug version does display records now, however the following error appears in the properties section:
Connection Error: SQB Service did not acknowledge receipt of data.(WAIT_TIMEOUT) / comments
As I stated earlier: The debug version does display records now, however the following error appears in the properties section:
Connection Error: SQB Service did not acknowledge receipt of data....
I am receiving this error after upgrading to 5.1 in the GUI engine.
System.InvalidCastException: Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Convert.ToInt32(Object value)
at _16._1(SqlConnection , _17 , Int32& , String& , Int32& )
at _16._1(SqlConnection , Int32& , String& )
at _16._1(Server , Int32& , String& )
at RedGate.SQLBackup.Engine.Server._10()
at RedGate.SQLBackup.Engine.Server.RefreshServerInformation()
at RedGate.SQLBackup.Engine.Server.OpenConnection()
Have followed the steps outlined in this posting with no success. (
1): Deleting records in msd tables
(2) removing entries from my documents folder
It appears that this error is only related to the GUI tool and not the master..sqlbackup procedure. All of our scheduled jobs which use this procedure are working. Our GUI is the one having issues with this error. Some of instances have this error and siome do not. Any idea what could be the issue? Any other work arounds? / comments
I am receiving this error after upgrading to 5.1 in the GUI engine.
System.InvalidCastException: Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToInt32(IForm...
For the 8198 error message, make sure that your domain account name for the SQLBackup service exactly matches your what is in the windows domain. Ex. if the account is XXXX\sqlusr in the windows domain, make sure the account for the service mathes the exact syntax.
We discovered this issue since some of our servers use the Latin 1 General Bin collation. We had entered xxxx\SQLUSR for the sqlbackup service which due to our sql server collation was not matching the account in the windows domain. The end result was the sql error 8198.
Changing the service account to exactly match the account in the windows domain solved the issue. / comments
For the 8198 error message, make sure that your domain account name for the SQLBackup service exactly matches your what is in the windows domain. Ex. if the account is XXXX\sqlusr in the windows ...
The link for error 8198 fixed our problem. Bottom line is to make sure that your service account matches your collation. / comments
The link for error 8198 fixed our problem. Bottom line is to make sure that your service account matches your collation.
I am receiving the following errors when running a restore:
Ex.
5/10/2007 11:00:48 AM: Error 890: RESTORE DATABASE permission denied for database: (Test)
5/10/2007 11:00:48 AM: SQL error 8198: Could not obtain information about Windows NT group/user 'domain\user account'.
Have followed the instructions per this posting of granting my domain\user account access to the master database
Changed service account to user\domain
Any ideas to what can is causing and work around for the sql error 8198
and Error 890? / comments
I am receiving the following errors when running a restore:
Ex.
5/10/2007 11:00:48 AM: Error 890: RESTORE DATABASE permission denied for database: (Test)
5/10/2007 11:00:48 AM: SQL error 8198: Cou...
Search the string for carriage return which is char(13) and replace with spaces seems to work. Also, can do the same for tab key.
Ex>
SET @sqlstring = 'master..sqlbackup N' + '''-SQL '+ '"'+ 'BACKUP DATABASE ' +
' TO DISK = ' + '' + 'WITH DIFFERENTIAL,COMPRESSION=1' + '"' + ''''
SET @sqlstring = REPLACE(@sqlstring,CHAR(13),'')
EXEC @rtn = sp_executesql @sqlstring / comments
Search the string for carriage return which is char(13) and replace with spaces seems to work. Also, can do the same for tab key.
Ex>
SET @sqlstring = 'master..sqlbackup N' + '''-SQL '+ '"'+ 'BACK...
Receive the following error when code is broken into seperate lines.
SQL Backup v4.6.0.815
Syntax error: '
DISK' after ','
name value
exitcode 850
sqlerrorcode 0
Do not see error when statement is one line. Can you verify. / comments
Receive the following error when code is broken into seperate lines.
SQL Backup v4.6.0.815
Syntax error: '
DISK' after ','
name value
exitcode 850
sqlerrorcode 0
Do not see error when statement is ...
Hi,
Any plans to add a retry option to your product if the file copyto fails to copy the file to the specified directory? / comments
Hi,
Any plans to add a retry option to your product if the file copyto fails to copy the file to the specified directory?