Comments
Sort by recent activity
Tried adding the key but no luck - no logs being created. [image] / comments
Tried adding the key but no luck - no logs being created.
Thanks Matt,
I saw that I could restore the backup from file
I deleted the cache and it resolved the issue
This happened this morning at 9.05am
Client
Windows XP SP3
Server
Windows Server 2003 SP2
SQL Server 2000 SP4
Nothing particularly obvious happening. When I performed another backup 10 minutes later I didnt have a problem.
I will turn the logging on to see if I can recreate the issue.
A / comments
Thanks Matt,
I saw that I could restore the backup from file
I deleted the cache and it resolved the issue
This happened this morning at 9.05am
Client
Windows XP SP3
Server
Windows Server 2003 SP2
...
matt,
I dont have the key HKEY_LOCAL_MACHINE\Software\Red Gate\SQL Backup\ ?
I created this as well.
I set the Full Logging to 1 as a string, Started SQL Backup GUI but cant see any logs being created? Where do the logs get created / comments
matt,
I dont have the key HKEY_LOCAL_MACHINE\Software\Red Gate\SQL Backup\ ?
I created this as well.
I set the Full Logging to 1 as a string, Started SQL Backup GUI but cant see any logs being cre...
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
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...
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
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 ...
Another occurrence of this problem on a different job [image] / comments
Another occurrence of this problem on a different job
And another [image] / comments
And another
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
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...
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
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...
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
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