How can we help you today? How can we help you today?
Andrew Hodge
Activity overview Badges (0) Posts (41) Comments (43)

Comments

Sort by recent activity
Hi David, This was why I wasn't sure if this feature request was actually a new product instead of a something that should be included in the SQL data compare tool. We have a number of applications which store documents (pdf, doc, rtf etc) and images in the text and images fields in SQL server. On a number of occasions we have had requests to extract/copy these documents and images out of the database and either modify or manipulate them. While we would expect the original application that loaded the image to the database to be able to do this we have had a variety of situations were the application has failed to be able to do this. One recent example is a user loads a very large file to the database ie an RTF file with embedded image at 45 MB. If we try to open the RTF in the loading application it times out and errors (I work for a local council and the quality of some of our application leaves something to be desired). As there are no native SQL tools to view the blob data we turn to 3rd party tools. I downloaded an application like the sqlimageviewer listed above and was able to export / view the RTF, see the issue with the size, modify it and import it again. As mentioned earlier in this thread the current 3rd party tools dont seem to be very well developed in my opinion. This was just an idea of a new product. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. feature request or new product
Hi David, This was why I wasn't sure if this feature request was actually a new product instead of a something that should be included in the SQL data compare tool. We have a number of applications...
0 votes
Thanks for pointing that software out, it is better than some of the other products I have seen. It still doesn't cover all eventualities though. We have things like .RTF .DOC etc stored in TEXT fields which this has mixed success in opening. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. feature request or new product
Thanks for pointing that software out, it is better than some of the other products I have seen. It still doesn't cover all eventualities though. We have things like .RTF .DOC etc stored in TEXT ...
0 votes
Another occurrence of this problem on a different job [image] / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Job duration unusual - Baseline incorrectly calculated
Another occurrence of this problem on a different job
0 votes
And another [image] / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Job duration unusual - Baseline incorrectly calculated
And another
0 votes
I have managed to resolve this using the same workaround as the issue with verify (stickied in the forum). But for completeness I deleted the local data cache located in the folder C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\SQL Backup\Server Data. This will cause the user interface to fetch the backup history data in order to create a new local cache which could have a temporary performance impact on the GUI. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. unable to restore using GUI
I have managed to resolve this using the same workaround as the issue with verify (stickied in the forum). But for completeness I deleted the local data cache located in the folder C:\Documents an...
0 votes
I have had this happen yesterday for all the full database backups on one of our servers. The odd thing is this only affects a remote GUI. It does not affect the GUI if I run it locally on the server however? Error 'SQL Backup has detected that more recent backups have used the same backup file name(s)' All our backups use the <AUTO> tag so include the date and time so the files do not have the same name? I have some screenshots of the error and lack there of if you are interested. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. unable to restore using GUI
I have had this happen yesterday for all the full database backups on one of our servers. The odd thing is this only affects a remote GUI. It does not affect the GUI if I run it locally on the se...
0 votes
I have full sa rights so I dont think this would be the issue. Will check the other things when I return to the office on friday. Many Thanks Andy H / comments
  1. Community
  2. SQL Compare Previous Versions
  3. An unexpected null value has been encountered while querying
I have full sa rights so I dont think this would be the issue. Will check the other things when I return to the office on friday. Many Thanks Andy H
0 votes
System.IndexOutOfRangeException: Index was outside the bounds of the array. at SNINativeMethodWrapper.SNIOpenEx(ConsumerInfo consumerInfo, String constring, IntPtr& pConn, Boolean fInitSec, Byte[] sspiBuffer, Byte[] instanceName, Boolean fOverrideCache, Boolean fSync) at System.Data.SqlClient.SNIHandle..ctor(ConsumerInfo myInfo, String serverName, Boolean integratedSecurity, Byte[] serverUserName, Boolean ignoreSniOpenTimeout, Int32 timeout, Byte[]& instanceName, Boolean flushCache, Boolean fSync) at System.Data.SqlClient.TdsParserStateObject.CreatePhysicalSNIHandle(String serverName, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Byte[]& instanceName, Boolean integratedSecurity, Byte[] serverUserName, Boolean flushCache, Boolean async) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at _23._1(String , Object ) at _16._1(Server , ConnectionInformation ) at RedGate.SQLBackup.Engine.Server.OpenConnection() / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup fails to connect on first start
System.IndexOutOfRangeException: Index was outside the bounds of the array. at SNINativeMethodWrapper.SNIOpenEx(ConsumerInfo consumerInfo, String constring, IntPtr& pConn, Boolean fInitSec, Byte[] ...
0 votes
Just experienced this issue as well. Is the fixed version listed here supported? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Logs [*] throws errors with databases in SIMPLE mode
Just experienced this issue as well. Is the fixed version listed here supported?
0 votes
Thanks for the prompt reply Pete. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup shows as completed successfully but actually failed
Thanks for the prompt reply Pete.
0 votes
Total activity
107
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
23