Activity overview
Latest activity by astreet
Log shipping jobs not deleting old .sqb files in 6.3
Log shipping jobs are not deleting old .sqb files from the log shipping share using FILEOPTIONS = 3. My restore log command has Erasefiles = 4 and Fileoptions =3 which should delete files older th...
New Feature for SQL BAckup 6.4
In our standby database environment, we backup transactions on the production database and ship them to the standby database without immediately applying the logs to the standby. We want to be able...
SQL Backup Restore logshipping delay
In our standby database environment, we backup transactions on the production database and ship them to the standby database without immediately applying the logs to the standby. We want to be able...
Configuring Log Shipping for multiple databases using GUI
How Configuring Log Shipping for multiple databases using Log Shipping Wizard? See that this command can be done with command line, however it would be helpful if this capability existed in the GUI.
This would be a great log shipping feature enhancement. / comments
This would be a great log shipping feature enhancement.
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....
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.
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.